题解 | #未完成试卷数大于1的有效用户#
未完成试卷数大于1的有效用户
https://www.nowcoder.com/practice/46cb7a33f7204f3ba7f6536d2fc04286
select uid,count(*)-count(submit_time) incomplete_cnt,count(submit_time) complete_cnt,group_concat(distinct concat_ws(':',substring(start_time,1,10),tag) separator ';')
from exam_record er
left join examination_info as ei
on er.exam_id = ei.exam_id
where date_format(start_time,'%Y') = 2021
group by uid
having count(score) >= 1 and count(*)-count(submit_time) < 5 and count(*)-count(submit_time) > 1
order by count(*)-count(submit_time) desc
