题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select
round(avg(score),0) as min_score_over_avg
from
exam_record as r
inner join examination_info as e on r.exam_id = e.exam_id
where
e.tag = 'SQL'
and score is not null
group by score
having score >= min_score_over_avg
limit
1
查看3道真题和解析
联想公司福利 1500人发布