题解 | #近三个月未完成试卷数为0的用户完成情况#
近三个月未完成试卷数为0的用户完成情况
http://www.nowcoder.com/practice/4a3acb02b34a4ecf9045cefbc05453fa
SELECT uid,COUNT(uid) exam_complete_cnt FROM( SELECT uid,submit_time, DENSE_RANK() OVER (PARTITION BY uid ORDER BY DATE_FORMAT(start_time,'%Y%m') DESC) month_rank FROM exam_record )t1 WHERE month_rank<=3 GROUP BY uid HAVING COUNT(uid) = COUNT(submit_time) ORDER BY exam_complete_cnt DESC,uid DESC;看uid和submit_time是否一致数量。
投递美团等公司10个岗位