*
SELECT stu.SID
, stu.Sname
, CAST(AVG(sc.score
) AS DECIMAL(18,2)) avg_score
FROM Student stu, SC sc
WHERE stu.SID
= sc.SID
GROUP BY stu.SID
, stu.Sname
HAVING CAST(AVG(sc.score
) AS DECIMAL(18,2)) >= 60;
Original: https://www.cnblogs.com/OnlyOnYourself-lzw/p/16567563.html
Author: OnlyOnYourself-Lzw
Title: Question03-查询平均成绩大于等于60分的同学的学生编号和学生姓名和平均成绩
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/621366/
转载文章受原作者版权保护。转载请注明原作者出处!