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