Oracle interview question

SQL queries, puzzles