select title,avg(s.salary) from titles t join salaries s on t.emp_no = s.emp_no group by title;