-- 问题提炼：统计各title类型的员工平均工资   以平均工资升序排序

SELECT
    t.title
    ,AVG(s.salary) AS `avg`
FROM titles t 
LEFT JOIN salaries s 
    ON t.emp_no = s.emp_no 
GROUP BY title
ORDER BY `avg`
;

END