Fidelity Investments Interview Question

Write SQL queries to achieve ...