Oracle Interview Question

SQL queries, puzzles