Morgan Stanley Interview Question

SQL query related to Joins.