#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 BETWEEN DATEADD(dd, -30, '2019-07-28') AND '2019-07-27'
GROUP BY activity_date

Previous#1084 Sales Analysis III Next#1148 Article Views I

Last updated 3 years ago

Was this helpful?

SELECT activity_date as day, COUNT(DISTINCT(user_id)) as active_users
FROM Activity 
WHERE activity_date BETWEEN DATEADD(dd, -30, '2019-07-28') AND '2019-07-27'
GROUP BY activity_date

https://leetcode.com/problems/user-activity-for-the-past-30-days-i/