题解 | #未完成试卷数大于1的有效用户#
未完成试卷数大于1的有效用户
https://www.nowcoder.com/practice/46cb7a33f7204f3ba7f6536d2fc04286
select uid,count(uid)-count(submit_time) a,count(submit_time) b,
group_concat(distinct concat_ws(':', date(start_time), tag) SEPARATOR ';') detail
from exam_record JOIN examination_info USING(exam_id)
where year(start_time) = 2021
group by uid
having b>=1 and a<5 and a>1
ORDER BY a desc
传音控股公司福利 356人发布
。佬可以试试