Question d’entretien chez Intercontinental Exchange

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