Oracle interview question

Sql question on Partitioning, self join etc