题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
/*
1、利用窗口函数对exam_id进行分区，并求出每个分区的平均年得分；
2、以1的计算结果为子表，对子表使用where进行过滤，得到score大于均值的数据，并通过min函数取最小值
*/
select
min(score) as min_score_over_avg
from
(select
e.score,avg(e.score) over(partition by e.exam_id) as avg_score
from exam_record as e left join examination_info as ei on e.exam_id=ei.exam_id
where tag='SQL') as tmp
where score >= avg_score
投递阿里巴巴灵犀互娱等公司10个岗位