Fidelity Investments Interview Question

Asked specific database Qs and had to come up with SQL queries based off scenerio