create view Dep_ MSalary as
select 部门名称,salary.月份,max(sum(salary.工资)) 最高工资,min(sum(salary.工资)) 最低工资
from Employee,Departments,Salary
where Employee.员工ID = Salary.员工ID
and Employee.部门ID = Departments.部门ID
group by 部门名称 ,salary.月份
如果需要限定 月份，则为：
create view Dep_ MSalary as
select 部门名称,max(sum(salary.工资)) 最高工资,min(sum(salary.工资)) 最低工资
from Employee,Departments,Salary
where Employee.员工ID = Salary.员工ID
and Employee.部门ID = Departments.部门ID
and salary.月份 = xxx
group by 部门名称
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024