题解 | 统计各个部门平均薪资
统计各个部门平均薪资
https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31
select
department,
round(avg(normal_salary-dock_salary),3) as avg_salary
from staff_tb
left join salary_tb using(staff_id)
where normal_salary-dock_salary between 4000 and 30000
group by department
order by avg_salary desc
投递中移(苏州)软件技术有限公司等公司10个岗位