select titles.title,avg(salaries.salary) from titles,salaries
where titles.emp_no=salaries.emp_no
group by titles.title