1141-user-activity-for-the-past-30-days-i

DevGod

Elf Vtuber

Tip

DevGod also tweets about solutions :)

Caution

DevGod needs to write an editorial for this problem!

sql

# Write your MySQL query statement below
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 activity_date