Capgemini interview question

Some SQL Queries