查询各个年龄段各部门人员的平均工资

查询各个年龄段各部门人员的平均工资

显示结果：
SQL语句：

select nld,销售部,研发部,行政部,发展部,运维部 from (select '20岁以下' nld,avg(CASE WHEN t1.dept = 1 THEN t1.salary ELSE NULL END) 销售部,avg(CASE WHEN t1.dept = 2 THEN t1.salary ELSE NULL END) 研发部,avg(CASE WHEN t1.dept = 3 THEN t1.salary ELSE NULL END) 行政部,avg(CASE WHEN t1.dept = 4 THEN t1.salary ELSE NULL END) 发展部,avg(CASE WHEN t1.dept = 5 THEN t1.salary ELSE NULL END) 运维部,1 seq from emp t1  where t1.age<20 
union 
select '20-30岁' nld,avg(CASE WHEN t2.dept = 1 THEN t2.salary ELSE NULL END) 销售部,avg(CASE WHEN t2.dept = 2 THEN t2.salary ELSE NULL END) 研发部,avg(CASE WHEN t2.dept = 3 THEN t2.salary ELSE NULL END) 行政部,avg(CASE WHEN t2.dept = 4 THEN t2.salary ELSE NULL END) 发展部,avg(CASE WHEN t2.dept = 5 THEN t2.salary ELSE NULL END) 运维部,2 seq from