题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) as min_score_over_avg
from exam_record
join examination_info using(exam_id)
where tag= 'SQL'
and score >= (
select avg(score)
from exam_record
join examination_info using(exam_id)
where tag = 'SQL'
)
#双and写法很意外
将min和avg分别书写
查看10道真题和解析
投递腾讯云智研发等公司7个岗位