Sql-视图 view

分别创建两个视图emp_deptview、emp_jobview，按部门、职位分别统计所有员工的年薪.

create view emp_deptview as select sum(12*(sal+ifnull(comm,0))) from emp group by deptno;
select * from emp_deptview;

create view emp_jobview as select sum(12*(sal+ifnull(comm,0))) from emp group by deptno;
select * from emp_jobtview;