题解 | #0级用户高难度试卷的平均用时和平均得分#

0级用户高难度试卷的平均用时和平均得分

http://www.nowcoder.com/practice/bb474c6cbd77478fb6d9fc86934d0ebb

    1. SELECT uid , ROUND(avg(score),0) AS avg_score,
    1. ROUND(avg(yongshi),1) AS avg_time_took
    1. FROM
    1. (SELECT uid,
    1. IF(submit_time IS NULL,duration,timestampdiff(minute,start_time,submit_time)) yongshi,
    1. IF(score IS NULL,0,score) as score
    1. FROM exam_record er LEFT JOIN examination_info ei
    1. ON er.exam_id = ei.exam_id
    1. WHERE difficulty = 'hard') a
    1. WHERE uid IN (SELECT uid FROM user_info WHERE level = 0)
    1. GROUP BY uid
全部评论

相关推荐

程序员小白条:找实习多投就行,但25届现在是春招时间呃呃呃,你想以后参加社招吗
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务