Domanda di colloquio di Fidelity Investments

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