select uid, count(if(submit_time is null,1,null)) as incomplete_cnt, count(if(submit_time is null,null,1)) as complete_cnt, group_concat(distinct concat_ws(':',date(start_time),tag)separator';') as detail from exam_record inner join examination_info using(exam_id) where year(start_time)=2021 group b...