题解 | #统计每天刷题数超过5的user_id以及刷题数#
统计每天刷题数超过5的user_id以及刷题数
https://www.nowcoder.com/practice/852a14b888c448f1a26f0e2e20f668a7
select `date`,
user_id,
sum(pass_count) as total_pass_count
from questions_pass_record_detail
group by user_id,`date`
having total_pass_count > 5;
分析好题意，记得先分组再筛选，group by 搭配 having。反引号`date`避免与SQL关键字冲突。
