CREATE VIEW VV_View(Sno,SUM_Cno,AVG_Score) AS SELECT Sno,COUNT(Cno),AVG(Score) FROM CS_View GROUP BY Sno
