题解 | #SQL类别高难度试卷得分的截断平均值#

SQL类别高难度试卷得分的截断平均值

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

select tag, difficulty, round(avg(score),1) as clip_avg_score FROM( exam_record as er left join examination_info as ei on er.exam_id = ei.exam_id ) where tag = 'SQL' and difficulty = 'hard' and score not in ( select max(score) FROM exam_record as er left join examination_info as ei on er.exam_id = ei.exam_id where tag = 'SQL' and difficulty = 'hard' ) and score not in ( select min(score) FROM exam_record as er left join examination_info as ei on er.exam_id = ei.exam_id where tag = 'SQL' and difficulty = 'hard' )

全部评论

相关推荐

自学java狠狠赚一...:骗你点star的,港卵公司,记得把star收回去
点赞 评论 收藏
分享
06-28 22:48
已编辑
广东金融学院 Java
小浪_Coding:学院本+这俩项目不是buff叠满了嘛
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务