题解 | #月均完成试卷数不小于3的用户爱作答的类别#
月均完成试卷数不小于3的用户爱作答的类别
http://www.nowcoder.com/practice/b1d13efcfa0c4ecea517afbdb9090845
SELECT tag, COUNT(tag) tag_cut FROM exam_record INNER JOIN examination_info USING(exam_id) WHERE uid IN ( SELECT uid FROM exam_record WHERE submit_time IS NOt NULL GROUP BY uid HAVING COUNT(exam_id) / COUNT(DISTINCT DATE_FORMAT(start_time, '%Y%m')) >= 3 ) GROUP BY tag ORDER BY tag_cut DESC;
投递阿里云等公司10个岗位