建立一个视图salary,该视图包括了仓库号和(该仓库的)平均工资两个字段,正确的SQL语句是:______。
A.CREATE VIEW salary AS 仓库号,AVG(工资)AS平均工资 FROM 职工表 GROUP BY 仓库号
B.CREATE VIEW salary AS SELECT 仓库号,AVG(工资)AS平均工资 FROM 职工表 GROUP BY 职工号
C.CREATE VIEW Salary SELECT 仓库号,AVG(工资)AS 平均工资 FROM 职工表 GROUP BY 仓库号
D.CREATE VIEW salary AS SELECT 仓库号,AVG(工资)AS 平均工资 FROM 职工表 GROUP BY仓库号