coder
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 2 additions & 2 deletions b/‎coderd/database/queries.sql.go
Lines changed: 2 additions & 2 deletions
diff --git a/‎coderd/database/queries/insights.sql
Lines changed: 2 additions & 2 deletions b/‎coderd/database/queries/insights.sql
Lines changed: 2 additions & 2 deletions
@@ -64,9 +64,9 @@ WITH app_stats AS (
 	FROM workspace_agent_stats was
 	WHERE
 		was.created_at >= @start_time::timestamptz
-		AND was.created_at @end_time::timestamptz
+		AND was.created_at < @end_time::timestamptz
 		AND was.connection_count > 0
-		AND CASE WHEN COALESCE(array_length(@template_ids::uuid[], 1), 0) > 0 THEN w.template_id = ANY(@template_ids::uuid[]) ELSE TRUE END
+		AND CASE WHEN COALESCE(array_length(@template_ids::uuid[], 1), 0) > 0 THEN was.template_id = ANY(@template_ids::uuid[]) ELSE TRUE END
 	GROUP BY date_trunc('minute', was.created_at), was.user_id, was.template_id
 ), combined_stats AS (
 	SELECT