SELECT
	T.title,
	avg(S.salary) AS "avg(s.salary)"  
FROM
	titles T
JOIN salaries S ON
	T.emp_no = S.emp_no
GROUP BY
	T.title
ORDER BY "avg(s.salary)" ASC

需要注意的是，avg(s.salary)作为字段名使用时，要加双引号""