34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT SelectCourse_StudentNo,AVG=AVG(SelectCourse_Score)
FROM SelectCourse
GROUP BY (SelectCourse_StudentNo)
HAVING AVG>80
CREATE VIEW V_AVG
AS
WITH V_AVG
AS ( SELECT SelectCourse_StudentNo ,
AVG = AVG(SelectCourse_Score)
FROM SelectCourse
GROUP BY ( SelectCourse_StudentNo )
)
SELECT *
FROM V_AVG
WHERE AVG > 80;