Pergunta de entrevista da empresa Intercontinental Exchange

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