Question d’entretien chez Fidelity Investments

I was asked to write a nested querry on a given database