题解 | #未完成试卷数大于1的有效用户#
未完成试卷数大于1的有效用户
https://www.nowcoder.com/practice/46cb7a33f7204f3ba7f6536d2fc04286
from exam_record
group by uid
having comple_cnt >= 1 and incomple_cnt < 5
)
select uid
, sum(if(submit_time is null, 1, 0)) incomplete_cnt
, sum(if(submit_time is null, 0, 1)) complete_cnt
, group_concat(distinct concat_ws(':', date(start_time), tag) separator ';') detail
from exam_record
left join examination_info using (exam_id)
where year(start_time) = '2021'
and uid in (select uid from active_uid)
group by uid
having incomplete_cnt > 1
order by incomplete_cnt desc
