select uid, sum(if(submit_time is null,1,null)) as incomplete_cnt, sum(if(submit_time is not null,1,null)) as complete_cnt, group_concat(distinct concat_ws(':',date(start_time),tag) order by start_time separator';') as detail from exam_record as er left join examination_info as ei on er.exam_id=ei....