Fidelity Investments interview question

Write SQL queries to achieve ...