Capgemini Interview Question

SQL query related to INNER JOIN