Leaderboard Dense Score Ranking

Medium

You are given a table named Scores with the following columns: id : unique row identifier score : numeric game score (decimal) Your task is to produce a ranked leaderboard using dense ranking rules: Higher scores must appear before lower scores. Identical scores must receive the same rank. Rank numbers must be consecutive after ties (no skipped rank values). Return one output row for every row in Scores, with exactly these columns and order: score rank Final output should be ordered by score descending . This problem must be solvable in both: SQL (SQLite 3.27.2) Pandas

Example 1

Input

Scores:
| id | score |
|----|-------|
| 1  | 3.50  |
| 2  | 3.65  |
| 3  | 4.00  |
| 4  | 3.85  |
| 5  | 4.00  |
| 6  | 3.65  |

Output

[
  {"score": 4.0, "rank": 1},
  {"score": 4.0, "rank": 1},
  {"score": 3.85, "rank": 2},
  {"score": 3.65, "rank": 3},
  {"score": 3.65, "rank": 3},
  {"score": 3.5, "rank": 4}
]

Explanation

Both rows with score 4.00 receive rank 1. The next distinct score (3.85) receives rank 2, and rank numbers remain consecutive without gaps.

Example 2

Input

Scores:
| id | score |
|----|-------|
| 7  | 9.10  |
| 8  | 8.25  |
| 9  | 7.75  |

Output

[
  {"score": 9.1, "rank": 1},
  {"score": 8.25, "rank": 2},
  {"score": 7.75, "rank": 3}
]

Explanation

All scores are distinct, so ranks are simply 1, 2, and 3 in descending score order.

Example 3

Input

Scores:
| id | score |
|----|-------|
| 10 | 5.00  |
| 11 | 5.00  |
| 12 | 5.00  |

Output

[
  {"score": 5.0, "rank": 1},
  {"score": 5.0, "rank": 1},
  {"score": 5.0, "rank": 1}
]

Explanation

When all rows have the same score, every row receives dense rank 1.

Constraints

1 <= number of rows in Scores <= 10,000
Scores.id is unique
Scores.score is a decimal value
Dense ranking must not skip rank numbers after ties
Output columns must be exactly: score, rank
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with columns: score, rank