•  

    I got it right by guessing, since the choice of words was misleading. The OVER clause is a CLAUSE, not a FUNCTION. And the DENSE_RANK* answer was almost right by not specifying if the ordering was done with the OVER clause or with an ORDER BY

    * Of course, DENSE_RANK doesn't leave gaps in the ordering sequence...but I never pretended I knew golf