题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
问题拆分
1、找到每个标签的平均值，这里标签是SQL
2、找到大于该平均值的每个分数
3、找到这些分数里面的最小值
select min(sq2.score) from
(select ei.exam_id,score from examination_info ei join exam_record er on ei.exam_id = er.exam_id join
(select tag,avg(score) as a_s from exam_record join examination_info using(exam_id) where tag='SQL') as sq1 on ei.tag = sq1.tag and score >= a_s) as sq2;
投递理想汽车等公司7个岗位 >
