• Seems like you are using Rank() instead of Dense_Rank()