Morgan Stanley interview question

SQL query related to Joins.