|
1
2
3
4
5
|
# Write your MySQL query statement below
SELECT activity_date AS day, COUNT(DISTINCT user_id) AS active_users
FROM Activity
WHERE DATEDIFF("2019-07-27", activity_date) < 30
GROUP BY activity_date
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1527. Patients With a Condition (0) | 2022.07.18 |
|---|---|
| leetcode 1729. Find Followers Count (0) | 2022.07.18 |
| leetcode 178. Rank Scores (0) | 2022.04.02 |
| leetcode 1158. Market Analysis I (0) | 2022.04.01 |
| leetcode 586. Customer Placing the Largest Number of Orders (0) | 2022.04.01 |
댓글