Fidelity Investments Interview Question

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