select t.title title, avg(s.salary) from
titles t inner join salaries s on t.emp_no=s.emp_no
group by title
order by avg(s.salary)
select t.title title, avg(s.salary) from
titles t inner join salaries s on t.emp_no=s.emp_no
group by title
order by avg(s.salary)
牛客博客，记录你的成长
京公网安备 11010502036488号