Update # 1141. User Activity for the Past 30 Days I.sql

dana3601 · web-flow · commit 74d78be5afdc · 2025-04-21T09:22:46.000+05:30
diff --git a/Social Media and Posts/# 1141. User Activity for the Past 30 Days I.sql b/Social Media and Posts/# 1141. User Activity for the Past 30 Days I.sql
@@ -5,6 +5,6 @@
 
 SELECT activity_date AS day, COUNT(DISTINCT user_id) AS active_users 
 FROM Activity
-WHERE DATEDIFF("2019-07-27", activity_date) < 30 
+WHERE DATEDIFF("2019-07-27", activity_date) < 30 and DATEDIFF("2019-07-27", activity_date) >= 0 --Date difference must be positive
 GROUP BY activity_date
 
