题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
http://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(exam_record.score) as min_score_over_avg
from exam_record, examination_info
where exam_record.exam_id = examination_info.exam_id and tag = 'SQL' and score >=
(select AVG(exam_record.score)
from exam_record, examination_info
where exam_record.exam_id = examination_info.exam_id and tag = 'SQL')
select min(e1.score) as min_score_over_avg from exam_record as e1, examination_info as e2 where e1.exam_id = e2.exam_id and tag = 'SQL' and score >= (select AVG(e1.score) from exam_record as e1, examination_info as e2 where e1.exam_id = e2.exam_id and tag = 'SQL')
投递小米集团等公司7个岗位