1141.sql (172B)
1 SELECT activity_date AS day, 2 COUNT(DISTINCT user_id) AS active_users 3 FROM Activity 4 WHERE activity_date BETWEEN '2019-06-28' AND '2019-07-27' 5 GROUP BY activity_date