select uid, count(if(submit_time is null,1,null)) incomplete_cnt, count(submit_time) complete_cnt, group_concat(distinct CONCAT(DATE_FORMAT(start_time, '%Y-%m-%d'),':',tag) separator ';') detail from examination_info i right join (select uid,exam_id,start_time,submit_time from ...