(29 ) 设有关系模式:教师表(教师号,教师名,所在系,工资),现需建立一个统计每个系全体教师工资总
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 SalaryView AS
SELECT 所在系, SUM(工资 ) FROM 教师表 GROUP BY 所在系