文章目录 题目代码(7.19 首刷自解) 题目 Leetcode 1141. 查询近30天活跃用户数 代码(7.19 首刷自解) # Write your MySQL query statement below select activity_date day, count(distinct user_id) active_users from activity where datediff('2019-07-27', activity_date)<30 and activity_date <= '2019-07-27' group by activity_date;