Oracle Interview Question

Sql question on Partitioning, self join etc