A.
CREATE VIEW SalaryView(系名,工资总额)AS SELECT所在系,COUNT(工资)FROM教师表GROUP BY所在系
B.
CREATE VIEW SalaryView(系名,工资总额)As SELECT所在系,SUM(工资)FROM教师表GROUP BY所在系
C.
CREATE VIEW SalaryVlew AS SELECT所在系,COUNT(工资)FROM教师表GROUP BY所在系
D.
CREATE VIEW salaryView AS SELECT所在系,SUM(工资)FROM教师表GROUP BY所在系