Oracle interview question

Group by, window functions and joins