Exercise

Fix the broken query

This query runs correctly, but gives an incorrect result in one of the rows because of an omission in the OVER clause. Can you locate the bug? Can you modify the query to make it give a reasonable result?

Instructions

100 XP

Provide the row number of the erroneous row as an integer.
Provide the clause (as a string) that when added to the OVER clause fixes the problem.