SELECT t.title,avg(s.salary)
FROM titles t
INNER JOIN salaries s 
on t.emp_no=s.emp_no
GROUP BY t.title
ORDER BY avg(s.salary)

关键：用内连接将两个表连在一起，注意内连接的连接条件用ON