题解 | #0级用户高难度试卷的平均用时和平均得分#
0级用户高难度试卷的平均用时和平均得分
http://www.nowcoder.com/practice/bb474c6cbd77478fb6d9fc86934d0ebb
select uid,
round(sum(if(score is not null,score,0))/count(1),0) as avg_score,
round(sum(if(score is NULL,duration,timestampdiff(minute,start_time,submit_time)))/count(1),1) as avg_time_took
from exam_record t
join examination_info t1 on t.exam_id = t1.exam_id
where uid in (select uid from user_info where level = 0) and difficulty = 'hard'
group by uid