Pregunta de entrevista de Intercontinental Exchange

to write a nested SQL query to derive from a employee dataset