Capgemini Interview Question

Few tricky SQL queries