题解 | 统计各个部门平均薪资
统计各个部门平均薪资
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 BETWEEN 4000 AND 30000
GROUP BY department
ORDER BY avg_salary DESC
查看9道真题和解析