题解 | #月均完成试卷数不小于3的用户爱作答的类别#题目有歧义，当月均完成数定义不清
月均完成试卷数不小于3的用户爱作答的类别
http://www.nowcoder.com/practice/b1d13efcfa0c4ecea517afbdb9090845
select tag,count(1) as tag_cnt from exam_record t1 join examination_info t2 on t1.exam_id = t2.exam_id where uid in ( select uid from exam_record where submit_time is not null group by uid having count(1)/count(distinct date_format(start_time,'%Y%m')) >= 3 ) group by tag order by tag_cnt desc
投递阿里巴巴灵犀互娱等公司10个岗位