Pergunta de entrevista da empresa Fidelity Investments

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