题解 | 统计出当前各个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;
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;
相关推荐