SELECT employee_id, last_name, salary
FROM employees
join
    (
        SELECT job_id, AVG(e.salary) AS avgsal
        FROM employees
        GROUP BY job_id
    )
using (job_id)
inner join
    (
        SELECT DISTINCT department_id
        FROM employees
        WHERE last_name LIKE '%t%'
    )
using (department_id)
WHERE salary > avgsal;