![](https://static.youtibao.com/asksite/comm/pc/images/content_title_q.png)
建立一个视图salary,该视图包括了系号和(该系的)平均工资两个字段,正确的SQL 语句是()
A.CREATE VIEW salary AS系号,AVG(工资)AS平均工资FROM教师;
GROUPBY系号
B.CREATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师;
GROUPBY系名
C.REATE VIEW Salary SELECT系号,AVG(工资)AS平均工资FROM教师;
GROUPBY系号
D.CREATEVIEW salaryAS SELECT系号,AVG(工资)AS平均工资FROM教师;
GROUPBY系号
![](https://static.youtibao.com/asksite/comm/pc/images/content_title_a.png)
D、CREATEVIEW salaryAS SELECT系号,AVG(工资)AS平均工资FROM教师;
GROUPBY系号