Oracle Interview Question

db query on joins