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