BNP Paribas interview question

Dbms queries.. Nested queries etc