题解 | #0级用户高难度试卷的平均用时和平均得分#
0级用户高难度试卷的平均用时和平均得分
https://www.nowcoder.com/practice/bb474c6cbd77478fb6d9fc86934d0ebb
select uid,round(avg(score),0) avg_score,round(avg(time_took),1) abg_time_took from ( select a.uid,ifnull(score,0) score ,if(submit_time is null,duration,timestampdiff(minute,start_time,submit_time)) time_took from exam_record a,examination_info b,user_info c where a.uid = c.uid and b.exam_id = a.exam_id and level = 0 and difficulty = 'hard' ) d group by uid;
海康威视二面101人在聊
查看25道真题和解析
