Oracle interview question

SQL Queries, Pivot