sql style

iskhakovt · iskhakovt · commit 5bac9fc8baff · 2022-09-12T00:18:38.000+01:00
diff --git a/coderd/database/queries/templates.sql b/coderd/database/queries/templates.sql
@@ -108,9 +108,12 @@ RETURNING
 
 -- name: GetTemplatesAverageBuildTime :many
 WITH query_with_all_job_count AS (SELECT
-    DISTINCT t.id,
+	DISTINCT t.id,
 	AVG(pj.exec_time_sec)
-	    OVER(PARTITION BY t.id ORDER BY pj.completed_at ROWS BETWEEN @moving_average_size::integer PRECEDING AND CURRENT ROW)
+		OVER(
+			PARTITION BY t.id
+			ORDER BY pj.completed_at
+			ROWS BETWEEN @moving_average_size::integer PRECEDING AND CURRENT ROW)
 		AS avg_build_time_sec,
 	COUNT(*) OVER(PARTITION BY t.id) as job_count
 FROM
@@ -121,33 +124,33 @@ FROM
 		templates) AS t
 LEFT JOIN
 	(SELECT
-	    workspace_id,
-	    template_version_id,
-	    job_id
+		workspace_id,
+		template_version_id,
+		job_id
 	FROM
-	    workspace_builds)
+		workspace_builds)
 	AS
-	    wb
+		wb
 ON
-    t.id = wb.workspace_id AND t.active_version_id = wb.template_version_id
+	t.id = wb.workspace_id AND t.active_version_id = wb.template_version_id
 LEFT JOIN
 	(SELECT
-	    id,
+		id,
 		completed_at,
 		EXTRACT(EPOCH FROM (completed_at - started_at)) AS exec_time_sec
 	FROM
-	    provisioner_jobs
+		provisioner_jobs
 	WHERE
-	    (completed_at IS NOT NULL) AND (started_at IS NOT NULL) AND
+		(completed_at IS NOT NULL) AND (started_at IS NOT NULL) AND
 		(completed_at >= @start_ts AND completed_at <= @end_ts) AND
-	    (canceled_at IS NULL) AND
-	    ((error IS NULL) OR (error = '')))
+		(canceled_at IS NULL) AND
+		((error IS NULL) OR (error = '')))
 	AS
-	    pj
+		pj
 ON
 	wb.job_id = pj.id)
 SELECT
-    id,
+	id,
 	avg_build_time_sec
 FROM
 	query_with_all_job_count
