select distinct ui.uid, round(sum(score)/count(*),0) as avg_score, round(avg(if(submit_time is null,duration,timestampdiff(minute,start_time,submit_time))),1) as avg_time_took from (user_info ui left join exam_record er on u...