# Write your MySQL query statement below
SELECT activity_date AS 'day', count(DISTINCT user_id) AS 'active_users'
FROM Activity
GROUP BY activity_date
HAVING datediff('2019-07-27', activity_date) >= 0 AND datediff('2019-07-27', activity_date) <=30
leetcode 1141 查询近30天活跃用户数
最新推荐文章于 2024-07-19 19:25:43 发布