Solve real challenges on SQL window functions, try to solve it hands on and check with the provided solutions.