Oracle Interview Question

SQL Queries, Pivot