Oracle interview question

db query on joins