题解 | 统计各个部门平均薪资
统计各个部门平均薪资
https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31
select a.department, round(avg(b.normal_salary-b.dock_salary),3) avg_salary from staff_tb a join salary_tb b on a.staff_id=b.staff_id where (b.normal_salary-b.dock_salary) between 4000 and 30000 group by a.department order by avg_salary desc
