题解 | 得分不小于平均分的最低分
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) as min_score_over_avg
from exam_record e_r join examination_info
on e_r.exam_id=examination_info.exam_id
where examination_info.tag='SQL'
and score>=(
select avg(score)
from exam_record e_r join examination_info
on e_r.exam_id=examination_info.exam_id
where tag='SQl'
)
美的集团公司福利 798人发布