建立一个视图salary,该视图包括了系号和(该系的)平均工资两个字段,正确的SQL语句是()
A.REATE VIEW salary AS系号,SVG(工资)AS平均工资FROM教师GROUP BY系号
B.REATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师GROUP BY系名
C.REATE VIEW Salary SELECT系号,AVG(工资)AS平均工资FROM教师GROUP BY系号
D.REATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师GROUP BY系号
D、REATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师GROUP BY系号