题解 | 得分不小于平均分的最低分
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
SELECT MIN(score) AS min_score_over_avg FROM exam_record AS a INNER JOIN examination_info AS b ON a.exam_id=b.exam_id WHERE score >= (SELECT AVG(score) FROM exam_record INNER JOIN examination_info ON exam_record.exam_id=examination_info.exam_id WHERE tag='SQL' ) AND tag='SQL';
查看30道真题和解析