题解 | #月均完成试卷数不小于3的用户爱作答的类别#
月均完成试卷数不小于3的用户爱作答的类别
http://www.nowcoder.com/practice/b1d13efcfa0c4ecea517afbdb9090845
select distinct(b.tag),count(b.tag) as tag_cnt from exam_record a inner join examination_info b ON a.exam_id = b.exam_id WHERE a.uid in (SELECT c.uid FROM exam_record c where c.submit_time is not null GROUP BY c.uid,month(c.submit_time) HAVING count(c.submit_time)>=3) GROUP BY b.tag ORDER BY tag_cnt DESC
汤臣倍健二面22人在聊
