What are the ids and full names for employees who work in a department that has someone with a first name that contains the letter T?
select employee_id, first_name, last_name from employees where department_id in ( select department_id from employees where first_name like '%t%' )