Genpact interview question

SQL queries & advanced plsql