select distinct title,
       avg(salary) over(partition by title) avg_salary
from titles 
left join salaries using(emp_no)
order by avg_salary

select 需要去重，否则会重复输出