题解 | #未完成试卷数大于1的有效用户#
SELECT r.uid,COUNT(1)-COUNT(r.submit_time) incomplete_cnt,COUNT(r.submit_time) complete_cnt, GROUP_CONCAT(DISTINCT CONCAT(DATE(r.start_time),':',i.tag) SEPARATOR ';') detail FROM exam_record r JOIN examination_info i ON r.exam_id=i.exam_id WHERE YEAR(start_time)='2021' GROUP BY r.uid HAVING complete_cnt>=1 AND incomplete_cnt<5 AND incomplete_cnt>1 ORDER BY incomplete_cnt DESC;
查看3道真题和解析
