select uid ,count(start_time)-count(submit_time) incomplete_cnt ,count(submit_time) complete_cnt ,replace(group_concat(distinct(left(start_time,10)),':',tag),',',';') detail from exam_record re join examination_info fo on re.exam_id = fo.exam_id where start_time is not null and start_time like "...
