题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
本题的难点在于需要先通过子查询找出平均值并且向上取整(ceil(avg)),之后在通过score进行一个数据判断
select
min(score) as min_score_over_avg
from
exam_record
join examination_info using (exam_id)
where
tag = "SQL"
AND score >= (
select
ceiling(avg(score)) as avgnum
from
exam_record
join examination_info using (exam_id)
where
tag = "SQL"
)
楼主你这双非和我们双非不一样啊，那4399我投简历，测评都不给我发