​下列SQL语句中，_________可以在“学生-课程”数据库正确实现“将学生的学号及他的平均成绩定义为一个视图”。‎ A: CREAT VIEW S_G(Sno，Gavg) AS SELECT Sno，AVG(Grade) FROM SCGROUP BY Sno； B: CREAT VIEW S_G(Sno，AVG(Grade)) AS SELECT Sno，AVG(Grade) FROM SCGROUP BY Sno； C: CREAT VIEW S_G AS SELECT Sno，AVG(Grade) FROM SCGROUP BY Sno； D: CREAT VIEW S_G(Sno，Gavg) AS SELECT Sno，AVG(Grade) FROM SCORDER BY Sno；