题解 | 得分不小于平均分的最低分
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
WITH
temp AS (
SELECT
score
FROM
exam_record
JOIN examination_info USING (exam_id)
WHERE
score IS NOT NULL
AND tag = 'SQL'
)
SELECT
MIN(score) AS min_score_over_avg
FROM
temp
WHERE
score >= (
SELECT
AVG(score)
FROM
temp
)
为啥老是报错:
程序异常退出, 请检查代码"是否有数组越界等异常"或者"是否有语法错误"
SQL_ERROR_INFO: "Unknown column 'uid' in 'field list'"

查看16道真题和解析