Oracle interview question

Puzzle , Sql query and oops concepts.