题解 | 0级用户高难度试卷的平均用时和平均得分
0级用户高难度试卷的平均用时和平均得分
https://www.nowcoder.com/practice/bb474c6cbd77478fb6d9fc86934d0ebb
SELECT ui.uid, ROUND(avg( if(score is null,0,er.score )) ,0), ROUND(avg( if (score is null,duration, TIMESTAMPDIFF(MINUTE,start_time,submit_time))),1) FROM user_info ui JOIN exam_record er ON ui.uid = er.uid AND ui.LEVEL = 0 JOIN examination_info ei ON ei.exam_id = er.exam_id AND ei.difficulty = 'hard' GROUP BY uid
腾讯成长空间 5893人发布