题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
SELECT MIN(a.score) AS min_score_over_avg
FROM(
SELECT r.score,
ROUND(AVG(r.score)OVER(PARTITION BY i.tag),0) AS score_avg
FROM exam_record AS r
LEFT JOIN examination_info AS i
ON r.exam_id = i.exam_id
WHERE i.tag = 'SQL'
) AS a
WHERE a.score >= score_avg
;
辅导员肯定不能同意，不然你出事了，他要承担责任。但是，脚和脑子都长在你自己身上，使用它还需要向辅导员报告么？
辅导员必须按流程拒绝你，然后你拿出成年人的态度，做自己的选择。