Oracle interview question

SQL queries based on joins