Capgemini interview question

SQL query related to INNER JOIN