题解 | #月均完成试卷数不小于3的用户爱作答的类别#
月均完成试卷数不小于3的用户爱作答的类别
https://www.nowcoder.com/practice/b1d13efcfa0c4ecea517afbdb9090845
with uid_f_use as ( select uid, count(1) complete_cnt from exam_record where submit_time is not null group by uid, date_format(submit_time, '%Y%m') having complete_cnt >= 3 ) select tag, count(1) tag_cnt from exam_record left join examination_info using (exam_id) where uid in (select uid from uid_f_use) group by tag order by tag_cnt desc
查看18道真题和解析