Nibav Lifts interview question

Rank VS Dense rank, window functions