Pregunta de entrevista de Oracle

Write an sql query which involved joins