题解 | #得分不小于平均分的最低分#

SELECT MIN(score) min_score_over_avg
FROM exam_record
WHERE exam_id IN (SELECT exam_id FROM examination_info WHERE tag = 'SQL')
AND score >=
(
    SELECT AVG(score) avg_score
    FROM exam_record
    WHERE exam_id IN (
            SELECT exam_id FROM examination_info WHERE tag = 'SQL'
    )
);

第一行找score 第五行是找平均得分 、 第三行是找id 嵌套有些复杂