Capgemini interview question

SQL Queries. Was again grilled on this.