select a.title title,avg(salary)
from titles a 
left join salaries b 
on a.emp_no = b.emp_no
group by a.title
order by avg(salary)

吐槽一下，展示表格给的字段名称，然后才发现它和答案核对时，只核对字段的数据