user-activity-for-the-past-30-days-i.sql

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 activity_date order by null;