ROW_NUMBER vs RANK vs DENSE_RANK

For each student show row_number, rank and dense_rank by score descending (break row_number ties by name). Order by row_number.

Table schema

Scores(name VARCHAR(10), score INT)

Sample data

name | score
Ann | 90
Bob | 90
Cy | 80
Dee | 70