Oracle interview question

Puzzles, SQL queries, and DSA