Fidelity Investments interview question

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