display the employee number and name( first name and last name ) for all employees who work in a department with any employee whose name contains a ’T’.
SELECT employee_id ,  first_name ,  last_name FROM employees WHERE department_id IN ( SELECT department_id FROM employees WHERE first_name LIKE '%T%' )
SELECT employee_id ,  first_name ,  last_name FROM employees WHERE department_id IN ( SELECT department_id FROM employees WHERE first_name LIKE '%T%' )
[{'EMPLOYEE_ID': 100, 'FIRST_NAME': 'Steven', 'LAST_NAME': 'King'}, {'EMPLOYEE_ID': 101, 'FIRST_NAME': 'Neena', 'LAST_NAME': 'Kochhar'}, {'EMPLOYEE_ID': 102, 'FIRST_NAME': 'Lex', 'LAST_NAME': 'De Haan'}, {'EMPLOYEE_ID': 120, 'FIRST_NAME': 'Matthew', 'LAST_NAME': 'Weiss'}, {'EMPLOYEE_ID': 121, 'FIRST_NAME': 'Adam', 'LAST_NAME': 'Fripp'}, {'EMPLOYEE_ID': 122, 'FIRST_NAME': 'Payam', 'LAST_NAME': 'Kaufling'}, {'EMPLOYEE_ID': 123, 'FIRST_NAME': 'Shanta', 'LAST_NAME': 'Vollman'}, {'EMPLOYEE_ID': 124, 'FIRST_NAME': 'Kevin', 'LAST_NAME': 'Mourgos'}, {'EMPLOYEE_ID': 125, 'FIRST_NAME': 'Julia', 'LAST_NAME': 'Nayer'}, {'EMPLOYEE_ID': 126, 'FIRST_NAME': 'Irene', 'LAST_NAME': 'Mikkilineni'}, {'EMPLOYEE_ID': 127, 'FIRST_NAME': 'James', 'LAST_NAME': 'Landry'}, {'EMPLOYEE_ID': 128, 'FIRST_NAME': 'Steven', 'LAST_NAME': 'Markle'}, {'EMPLOYEE_ID': 129, 'FIRST_NAME': 'Laura', 'LAST_NAME': 'Bissot'}, {'EMPLOYEE_ID': 130, 'FIRST_NAME': 'Mozhe', 'LAST_NAME': 'Atkinson'}, {'EMPLOYEE_ID': 131, 'FIRST_NAME': 'James', 'LAST_NAME': 'Marlow'}, {'EMPLOYEE_ID': 132, 'FIRST_NAME': 'TJ', 'LAST_NAME': 'Olson'}, {'EMPLOYEE_ID': 133, 'FIRST_NAME': 'Jason', 'LAST_NAME': 'Mallin'}, {'EMPLOYEE_ID': 134, 'FIRST_NAME': 'Michael', 'LAST_NAME': 'Rogers'}, {'EMPLOYEE_ID': 135, 'FIRST_NAME': 'Ki', 'LAST_NAME': 'Gee'}, {'EMPLOYEE_ID': 136, 'FIRST_NAME': 'Hazel', 'LAST_NAME': 'Philtanker'}, {'EMPLOYEE_ID': 137, 'FIRST_NAME': 'Renske', 'LAST_NAME': 'Ladwig'}, {'EMPLOYEE_ID': 138, 'FIRST_NAME': 'Stephen', 'LAST_NAME': 'Stiles'}, {'EMPLOYEE_ID': 139, 'FIRST_NAME': 'John', 'LAST_NAME': 'Seo'}, {'EMPLOYEE_ID': 140, 'FIRST_NAME': 'Joshua', 'LAST_NAME': 'Patel'}, {'EMPLOYEE_ID': 141, 'FIRST_NAME': 'Trenna', 'LAST_NAME': 'Rajs'}, {'EMPLOYEE_ID': 142, 'FIRST_NAME': 'Curtis', 'LAST_NAME': 'Davies'}, {'EMPLOYEE_ID': 143, 'FIRST_NAME': 'Randall', 'LAST_NAME': 'Matos'}, {'EMPLOYEE_ID': 144, 'FIRST_NAME': 'Peter', 'LAST_NAME': 'Vargas'}, {'EMPLOYEE_ID': 145, 'FIRST_NAME': 'John', 'LAST_NAME': 'Russell'}, {'EMPLOYEE_ID': 146, 'FIRST_NAME': 'Karen', 'LAST_NAME': 'Partners'}, {'EMPLOYEE_ID': 147, 'FIRST_NAME': 'Alberto', 'LAST_NAME': 'Errazuriz'}, {'EMPLOYEE_ID': 148, 'FIRST_NAME': 'Gerald', 'LAST_NAME': 'Cambrault'}, {'EMPLOYEE_ID': 149, 'FIRST_NAME': 'Eleni', 'LAST_NAME': 'Zlotkey'}, {'EMPLOYEE_ID': 150, 'FIRST_NAME': 'Peter', 'LAST_NAME': 'Tucker'}, {'EMPLOYEE_ID': 151, 'FIRST_NAME': 'David', 'LAST_NAME': 'Bernstein'}, {'EMPLOYEE_ID': 152, 'FIRST_NAME': 'Peter', 'LAST_NAME': 'Hall'}, {'EMPLOYEE_ID': 153, 'FIRST_NAME': 'Christopher', 'LAST_NAME': 'Olsen'}, {'EMPLOYEE_ID': 154, 'FIRST_NAME': 'Nanette', 'LAST_NAME': 'Cambrault'}, {'EMPLOYEE_ID': 155, 'FIRST_NAME': 'Oliver', 'LAST_NAME': 'Tuvault'}, {'EMPLOYEE_ID': 156, 'FIRST_NAME': 'Janette', 'LAST_NAME': 'King'}, {'EMPLOYEE_ID': 157, 'FIRST_NAME': 'Patrick', 'LAST_NAME': 'Sully'}, {'EMPLOYEE_ID': 158, 'FIRST_NAME': 'Allan', 'LAST_NAME': 'McEwen'}, {'EMPLOYEE_ID': 159, 'FIRST_NAME': 'Lindsey', 'LAST_NAME': 'Smith'}, {'EMPLOYEE_ID': 160, 'FIRST_NAME': 'Louise', 'LAST_NAME': 'Doran'}, {'EMPLOYEE_ID': 161, 'FIRST_NAME': 'Sarath', 'LAST_NAME': 'Sewall'}, {'EMPLOYEE_ID': 162, 'FIRST_NAME': 'Clara', 'LAST_NAME': 'Vishney'}, {'EMPLOYEE_ID': 163, 'FIRST_NAME': 'Danielle', 'LAST_NAME': 'Greene'}, {'EMPLOYEE_ID': 164, 'FIRST_NAME': 'Mattea', 'LAST_NAME': 'Marvins'}, {'EMPLOYEE_ID': 165, 'FIRST_NAME': 'David', 'LAST_NAME': 'Lee'}, {'EMPLOYEE_ID': 166, 'FIRST_NAME': 'Sundar', 'LAST_NAME': 'Ande'}, {'EMPLOYEE_ID': 167, 'FIRST_NAME': 'Amit', 'LAST_NAME': 'Banda'}, {'EMPLOYEE_ID': 168, 'FIRST_NAME': 'Lisa', 'LAST_NAME': 'Ozer'}, {'EMPLOYEE_ID': 169, 'FIRST_NAME': 'Harrison', 'LAST_NAME': 'Bloom'}, {'EMPLOYEE_ID': 170, 'FIRST_NAME': 'Tayler', 'LAST_NAME': 'Fox'}, {'EMPLOYEE_ID': 171, 'FIRST_NAME': 'William', 'LAST_NAME': 'Smith'}, {'EMPLOYEE_ID': 172, 'FIRST_NAME': 'Elizabeth', 'LAST_NAME': 'Bates'}, {'EMPLOYEE_ID': 173, 'FIRST_NAME': 'Sundita', 'LAST_NAME': 'Kumar'}, {'EMPLOYEE_ID': 174, 'FIRST_NAME': 'Ellen', 'LAST_NAME': 'Abel'}, {'EMPLOYEE_ID': 175, 'FIRST_NAME': 'Alyssa', 'LAST_NAME': 'Hutton'}, {'EMPLOYEE_ID': 176, 'FIRST_NAME': 'Jonathon', 'LAST_NAME': 'Taylor'}, {'EMPLOYEE_ID': 177, 'FIRST_NAME': 'Jack', 'LAST_NAME': 'Livingston'}, {'EMPLOYEE_ID': 179, 'FIRST_NAME': 'Charles', 'LAST_NAME': 'Johnson'}, {'EMPLOYEE_ID': 180, 'FIRST_NAME': 'Winston', 'LAST_NAME': 'Taylor'}, {'EMPLOYEE_ID': 181, 'FIRST_NAME': 'Jean', 'LAST_NAME': 'Fleaur'}, {'EMPLOYEE_ID': 182, 'FIRST_NAME': 'Martha', 'LAST_NAME': 'Sullivan'}, {'EMPLOYEE_ID': 183, 'FIRST_NAME': 'Girard', 'LAST_NAME': 'Geoni'}, {'EMPLOYEE_ID': 184, 'FIRST_NAME': 'Nandita', 'LAST_NAME': 'Sarchand'}, {'EMPLOYEE_ID': 185, 'FIRST_NAME': 'Alexis', 'LAST_NAME': 'Bull'}, {'EMPLOYEE_ID': 186, 'FIRST_NAME': 'Julia', 'LAST_NAME': 'Dellinger'}, {'EMPLOYEE_ID': 187, 'FIRST_NAME': 'Anthony', 'LAST_NAME': 'Cabrio'}, {'EMPLOYEE_ID': 188, 'FIRST_NAME': 'Kelly', 'LAST_NAME': 'Chung'}, {'EMPLOYEE_ID': 189, 'FIRST_NAME': 'Jennifer', 'LAST_NAME': 'Dilly'}, {'EMPLOYEE_ID': 190, 'FIRST_NAME': 'Timothy', 'LAST_NAME': 'Gates'}, {'EMPLOYEE_ID': 191, 'FIRST_NAME': 'Randall', 'LAST_NAME': 'Perkins'}, {'EMPLOYEE_ID': 192, 'FIRST_NAME': 'Sarah', 'LAST_NAME': 'Bell'}, {'EMPLOYEE_ID': 193, 'FIRST_NAME': 'Britney', 'LAST_NAME': 'Everett'}, {'EMPLOYEE_ID': 194, 'FIRST_NAME': 'Samuel', 'LAST_NAME': 'McCain'}, {'EMPLOYEE_ID': 195, 'FIRST_NAME': 'Vance', 'LAST_NAME': 'Jones'}, {'EMPLOYEE_ID': 196, 'FIRST_NAME': 'Alana', 'LAST_NAME': 'Walsh'}, {'EMPLOYEE_ID': 197, 'FIRST_NAME': 'Kevin', 'LAST_NAME': 'Feeney'}, {'EMPLOYEE_ID': 198, 'FIRST_NAME': 'Donald', 'LAST_NAME': 'OConnell'}, {'EMPLOYEE_ID': 199, 'FIRST_NAME': 'Douglas', 'LAST_NAME': 'Grant'}, {'EMPLOYEE_ID': 201, 'FIRST_NAME': 'Michael', 'LAST_NAME': 'Hartstein'}, {'EMPLOYEE_ID': 202, 'FIRST_NAME': 'Pat', 'LAST_NAME': 'Fay'}]