题解 | #未完成试卷数大于1的有效用户#

select d.uid, (count(start_time)-count(submit_time)) as incomplete_cnt, count(submit_time) as complete_cnt , group_concat(distinct(concat(date_format(d.start_time,'%Y-%m-%d'),':',o.tag)) separator ';') as detail from exam_record d inner join examination_info o on d.exam_id = o.exam_id where year(d.start_time) = '2021' group by d.uid having complete_cnt >= 1 and incomplete_cnt BETWEEN 2 and 4 order by incomplete_cnt desc