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

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

全部评论

相关推荐

accaacc:2到4k,不是2k到4k,所以年薪是30块
点赞 评论 收藏
分享
评论
1
收藏
分享
牛客网
牛客企业服务