I appreciate these questions every day, helps me learn new things, so I don't want to sound like a nob here, but surely the question is wrong?
'If I have this data?
CustomerID Sales
1 100
2 50
3 50
4 120'
Working on that, to get it as 1,2,3,4 DENSE_RANK() would not work, as it would be 1,2,3,3.
In the answer, it gives the data as:
VALUES
( 1, 100), ( 2, 50), (3, 50), (4, 120), (5, 25)
Which would relate to 1,2,3,3,4 as the question asks.
A good one for me to look at from a learning point of view, as I had to look into the data to understand, but at first I was massively confused my answer of row_number was incorrect!