题解 | 统计各个部门平均薪资
统计各个部门平均薪资
https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31
select s.department,round(avg(sa.normal_salary-sa.dock_salary),3) as avg_salary from staff_tb s join salary_tb sa on s.staff_id = sa.staff_id where sa.normal_salary - sa.dock_salary between 4000 and 30000 group by s.department order by avg_salary desc
简单
投递曼伦商贸等公司6个岗位 >
