Capgemini interview question

correlated subqueries