题解 | 统计出当前各个title类型对应的员工当前薪水对应的平均工资
with tmp as ( select t1.title,t2.salary from titles as t1 inner join salaries as t2 on t1.emp_no = t2.emp_no) select t.title as title,avg(t.salary) from tmp as t group by t.title order by avg(t.salary) asc;
2025-01-21 16:14 上海对外经贸大学 数据分析师 发布于内蒙古
关注
全部评论
相关推荐
点赞 评论 收藏
分享
点赞 评论 收藏
分享