题解 | 统计每天刷题数超过5的user_id以及刷题数
select date, user_id, sum(pass_count) total_pass_count from questions_pass_record_detail group by date,user_id having sum(pass_count)>5
select date, user_id, sum(pass_count) total_pass_count from questions_pass_record_detail group by date,user_id having sum(pass_count)>5
相关推荐