下列定义视图的语句,正确的是()。
A.CREATE VIEW V1 AS SELECT Sno, MAX(Grade) FROM SC GROUP BY Sno
B.CREATE VIEW V1 (max_ g) AS SELECT Sno, MAX (Grade) FROM SC GROUP BY Sno
C.CREATE VIEW V1(Sno) AS SELECT Sno, MAX(Grade) FROM SC GROUP BY Sno
D.CREATE VIEW V1(Sno, max_ g) AS SELECT Sno, MAX(Grade) FROM SC GROUP BY Sno