题解 | 统计各个部门平均薪资

SELECT 
    department,
    ROUND(avg(normal_salary - dock_salary),3) AS avg_salary
FROM staff_tb
JOIN salary_tb USING (staff_id)
WHERE normal_salary - dock_salary BETWEEN 4000 AND 30000
GROUP BY department
ORDER BY avg_salary DESC