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%')
``` yaml
employees: # name of dataframe
- EMPLOYEE_ID:
    dtype: int64
    sample_values: 100, 101, 102
- FIRST_NAME:
    dtype: string
    sample_values: Steven, Neena, Lex
- LAST_NAME:
    dtype: string
    sample_values: King, Kochhar, De Haan
- EMAIL:
    dtype: string
    sample_values: SKING, NKOCHHAR, LDEHAAN
- PHONE_NUMBER:
    dtype: string
    sample_values: 515.123.4567, 515.123.4568, 515.123.4569
- HIRE_DATE:
    dtype: datetime
    sample_values: 1987-06-17, 1987-06-18, 1987-06-19
- JOB_ID:
    dtype: string
    sample_values: AD_PRES, AD_VP, AD_VP
- SALARY:
    dtype: int64
    sample_values: 24000, 17000, 17000
- COMMISSION_PCT:
    dtype: float64
    sample_values: 0.0, 0.0, 0.0
- MANAGER_ID:
    dtype: int64
    sample_values: 0, 100, 100
- DEPARTMENT_ID:
    dtype: int64
    sample_values: 90, 90, 90

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