题解 | 统计各个部门平均薪资
统计各个部门平均薪资
https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31
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 >= 4000 AND normal_salary - dock_salary <= 30000
GROUP BY department
ORDER BY avg_salary DESC
查看18道真题和解析