Oracle Interview Question

Some puzzles, i dont recall but were basic to verify analytics.