题解 | #统计每天刷题数超过5的user_id以及刷题数#
统计每天刷题数超过5的user_id以及刷题数
https://www.nowcoder.com/practice/852a14b888c448f1a26f0e2e20f668a7
select
*
from
(
select
date,
user_id,
sum(pass_count) as total_pass_count
from
questions_pass_record_detail
group by
date,
user_id
) as t
where t.total_pass_count >5
投递深圳虾皮信息科技有限公司等公司10个岗位