Oracle interview question

Write some SQL query.