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

统计各个部门平均薪资

https://www.nowcoder.com/practice/4722fdf89a4c43eebb58d61a19ccab31

with salary as(
select staff_id
, normal_salary-dock_salary sum_salary
from salary_tb
where (normal_salary-dock_salary) between 4000 and 30000
)

select department
, avg(sum_salary) avg_salary
from staff_tb
left join salary
on staff_tb.staff_id = salary.staff_id
group by  1
order by 2 desc

全部评论

相关推荐

醉蟀:你不干有的是人干
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务