题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
http://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
这题没有写出来 参考大佬的
select min(er.score) as min_score_over_avg
from exam_record er join examination_info ei
on er.exam_id = ei.exam_id
where ei.tag = 'SQL'
and score >= (select avg(er2.score)
from exam_record er2
join examination_info ei2
on er2.exam_id = ei2.exam_id
where tag = 'SQL'
)
海信集团二面10人在聊
佬没投鹅吗，鹅应该很喜欢北邮吧
投递美团等公司10个岗位