Oracle interview question

SQL queries