Report question

Question: Example of an Oracle PIVOT clause with subquery