I should have gone with my gut on this one. When I got the same results using rank and dense_rank, I decided I must be misunderstanding the intent of the question and went with row_number. :unsure: I had very little confidence in getting this right because the sample output in the question confused me. That's what I get for focusing too much on the sample and not just following along with the overall intent.