SELECT statement to choose the columns score and the DENSE_RANK() function.DENSE_RANK() function over the window defined by ordering the scores in descending order using the OVER() clause.DENSE_RANK() function as 'rank'.FROM clause to specify the Scores table as the source of the data.ORDER BY clause to sort the final result set by score in descending order.
erDiagram
Scores {
int id PK
decimal score
}