select e.employee_id, e.last)name, e.salary
from employees e
join (select job_id, avg(e.salary) as avgsal from employees group by e.job_id) g on e.job_id = g.job_id and e.salary > g.avgsal
inner join (select d.department_id as depid from departaments join employees on depid=e.department_id and e.last_name like '%t%') d on e.department_id = d.department_id;