题目来源:
leetcode题目,网址:1141. 查询近30天活跃用户数 - 力扣(LeetCode)
解题思路:
分组聚合后筛选计数即可。
解题代码:
# 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 activity_date between '2019-06-28' and '2019-07-27'
总结:
sql 中 between ... and ... 若前者较大,后者较小,必定无符合要求的项。