Skip to content

1141. User Activity for the Past 30 Days I 👎

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