leet_sql_9_1141. User Activity for the Past 30 Days I

select  activity_date as day ,COUNT(DISTINCT user_id) AS active_users
FROM Activity
WHERE (activity_date > '2019-06-27' AND activity_date <= '2019-07-27')
GROUP BY 1;