SELECT
sno,
AVG(grade)
FROM
sc
GROUP BY
sno
HAVING
AVG(grade) >= 90;
21. 查询表sc——查询平均成绩大于等于90分的学生学号和平均成绩
最新推荐文章于 2022-10-15 13:06:31 发布
SELECT
sno,
AVG(grade)
FROM
sc
GROUP BY
sno
HAVING
AVG(grade) >= 90;