SELECT ui.uid, SUM(IF(score IS NULL AND start_time IS NOT NULL,1,0)) incomplete_cnt, ROUND(AVG(IF(score IS NULL AND start_time IS NOT NULL,1,0)),3) incomplete_rate from user_info ui left join exam_record er using(uid) where if((SELECT ui.uid FROM user_info as ui LEFT JOIN exam_record as er ...