Fidelity Investments interview question

Write a SQL query that returns these specific columns. Perform a join on these two tables.