create view V_average_point
as
select B.Sdept,A.Sno,avg(A.point) Average_point
from (
select Sno,Cno,if(Grade>=60,(Grade-50)/10,0) point
from SC
)A,Student B,Course C
where A.Sno=B.Sno and C.Cno = A.Cno
group by A.Sno
从这道题里学到的是,需要更改的字段作为辅助查询对象时可以自己创造出一个表来
这里就通过select语句创建了一个表并且将其命名为了A