Oracle Interview Question

Group by, window functions and joins