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