题解 | 统计各个部门平均薪资
统计各个部门平均薪资
https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31
SELECT
department,
AVG(normal_salary - dock_salary) AS avg_salary
FROM staff_tb JOIN salary_tb
ON staff_tb.staff_id = salary_tb.staff_id
WHERE (normal_salary - dock_salary) BETWEEN 4000 AND 30000
GROUP BY department
ORDER BY avg_salary DESC
