Publicis Sapient interview question

SQL query for joins.