题解 | #统计每天刷题数超过5的user_id以及刷题数#
统计每天刷题数超过5的user_id以及刷题数
https://www.nowcoder.com/practice/852a14b888c448f1a26f0e2e20f668a7
1. 一人一天只能刷一种题型
select date, user_id, pass_count total_pass_count from questions_pass_record_detail where pass_count > 5
2. 一人一天可以刷多种题型
select date, user_id, sum(pass_count) total_pass_count from questions_pass_record_detail group by user_id, date having sum(pass_count) > 5
查看5道真题和解析
