题解 | 统计各个部门平均薪资
统计各个部门平均薪资
https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31
select st.department ,avg((sb.normal_salary - sb.dock_salary)) as avg_salary from staff_tb as st left join salary_tb as sb on st.staff_id=sb.staff_id where (sb.normal_salary - sb.dock_salary) between 4000 and 30000 group by st.department order by avg_salary desc;
美团公司氛围 2358人发布