ROW_NUMBER() OVER (PARTITION BY column ORDER BY value )
is equivalent to
COUNT(*) OVER (PARTITION BY column ORDER BY value ROWS UNBOUNDED PRECEDING).
ROW_NUMBER() OVER (PARTITION BY column ORDER BY value )
is equivalent to
COUNT(*) OVER (PARTITION BY column ORDER BY value ROWS UNBOUNDED PRECEDING).