Capgemini Interview Question

SQL Queries. Was again grilled on this.