题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
SELECT MIN(score)as min_score_over_avg FROM exam_record AS er JOIN examination_info AS ei ON er.exam_id = ei.exam_id WHERE ei.tag = 'SQL' AND score >= (SELECT AVG(score) FROM exam_record as e_r JOIN examination_info AS e_i ON e_r.exam_id = e_i.exam_id WHERE e_i.tag = 'SQL');
查看14道真题和解析
投递中国移动等公司10个岗位