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