题解 | 统计各个部门平均薪资-SQL
统计各个部门平均薪资
https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31
select
department,
round(avg(normal_salary - dock_salary), 3) as avg_salary
from
salary_tb as a
inner join staff_tb as b on a.staff_id = b.staff_id
where
normal_salary - dock_salary >= 4000
and normal_salary - dock_salary <= 30000
group by
department
order by
avg_salary desc;
查看13道真题和解析
，继续战！
没有赛事奖项么？另外，项目经历字有点多哈，建议突出一下重点：用的什么技术，解决什么问题，达到什么效果。
