题解 | #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' )

全部评论

相关推荐

07-18 14:34
门头沟学院 Java
感觉招聘要求好高,这都是招什么人才
电气电子小朋友:你都说了这是大疆,无人机顶级企业,薪资30k-50k,要求高是正常的
点赞 评论 收藏
分享
不愿透露姓名的神秘牛友
07-16 18:05
何尝不是一种学历歧视呢
下午吃泡馍:这种公司不投也罢,不过建议挂出公司名字,1.1w就应激到问是不是清北也是看得出来不是啥好公司了,估计这hr也没见过啥世面
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

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