题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
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
;
投递商米等公司7个岗位 >
华为开奖102人在聊