select titles.title, avg(salaries.salary) as avg
from salaries, titles
where titles.to_date='9999-01-01' and salaries.to_date='9999-01-01'
and salaries.emp_no = titles.emp_no
group by titles.title