Publicis Sapient Interview Question

SQL query for joins.