题解 | #月均完成试卷数不小于3的用户爱作答的类别#
月均完成试卷数不小于3的用户爱作答的类别
https://www.nowcoder.com/practice/b1d13efcfa0c4ecea517afbdb9090845
select tag,count(start_time) as tag_cnt
from exam_record t1
left join examination_info t2
on t1.exam_id = t2.exam_id
where uid in
(
select uid
from exam_record
group by uid
having count(submit_time)/count(distinct date_format(submit_time,"%Y%m")) >= 3
)
group by tag
order by tag_cnt desc
滴滴公司福利 1026人发布
投递阿里巴巴集团等公司8个岗位
