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