coder
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 9 additions & 4 deletions b/‎coderd/database/queries.sql.go
Lines changed: 9 additions & 4 deletions
diff --git a/‎coderd/database/queries/insights.sql
Lines changed: 9 additions & 4 deletions b/‎coderd/database/queries/insights.sql
Lines changed: 9 additions & 4 deletions
@@ -94,11 +94,16 @@ WITH d AS (
 	GROUP BY ts.from_, ts.to_, was.user_id
 ), template_ids AS (
 	SELECT
-		from_,
-		array_agg(DISTINCT template_id) AS ids
-	FROM usage_by_day, unnest(template_ids) template_id
+		template_usage_by_day.from_,
+		array_agg(template_id) AS ids
+	FROM (
+		SELECT DISTINCT
+			from_,
+			unnest(template_ids) AS template_id
+		FROM usage_by_day
+	) AS template_usage_by_day
 	WHERE template_id IS NOT NULL
-	GROUP BY from_, template_ids
+	GROUP BY template_usage_by_day.from_
 )
 
 SELECT