Medal Table Ranking with Cascading Tie-Breakers

Easy

An international sports analytics desk stores medal counts by country and needs a deterministic leaderboard for publishing and downstream reporting. Table: MedalStandings country: unique country name gold_medals: number of gold medals won silver_medals: number of silver medals won bronze_medals: number of bronze medals won Task: Return the same rows sorted by ranking priority: higher gold_medals first if tied, higher silver_medals first if tied, higher bronze_medals first if still tied, country ascending lexicographically Output requirements: Return exactly these columns: country, gold_medals, silver_medals, bronze_medals All rows must appear exactly once Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

MedalStandings:
| country     | gold_medals | silver_medals | bronze_medals |
|-------------|-------------|---------------|---------------|
| China       | 10          | 10            | 20            |
| South Sudan | 0           | 0             | 1             |
| USA         | 10          | 10            | 20            |
| Israel      | 2           | 2             | 3             |
| Egypt       | 2           | 2             | 2             |

Output

[
  {"country":"China","gold_medals":10,"silver_medals":10,"bronze_medals":20},
  {"country":"USA","gold_medals":10,"silver_medals":10,"bronze_medals":20},
  {"country":"Israel","gold_medals":2,"silver_medals":2,"bronze_medals":3},
  {"country":"Egypt","gold_medals":2,"silver_medals":2,"bronze_medals":2},
  {"country":"South Sudan","gold_medals":0,"silver_medals":0,"bronze_medals":1}
]

Explanation

China and USA tie on all medal counts, so country name breaks the tie. Israel beats Egypt on bronze medals after gold and silver ties.

Example 2

Input

MedalStandings:
| country     | gold_medals | silver_medals | bronze_medals |
|-------------|-------------|---------------|---------------|
| Aland       | 5           | 4             | 3             |
| Borealis    | 5           | 4             | 3             |
| Cyrenia     | 5           | 4             | 2             |
| Dalmora     | 6           | 0             | 0             |
| Estoria     | 5           | 5             | 0             |

Output

[
  {"country":"Dalmora","gold_medals":6,"silver_medals":0,"bronze_medals":0},
  {"country":"Estoria","gold_medals":5,"silver_medals":5,"bronze_medals":0},
  {"country":"Aland","gold_medals":5,"silver_medals":4,"bronze_medals":3},
  {"country":"Borealis","gold_medals":5,"silver_medals":4,"bronze_medals":3},
  {"country":"Cyrenia","gold_medals":5,"silver_medals":4,"bronze_medals":2}
]

Explanation

The ranking cascade applies left to right: gold, then silver, then bronze, then country.

Example 3

Input

MedalStandings:
| country    | gold_medals | silver_medals | bronze_medals |
|------------|-------------|---------------|---------------|
| Country 10 | 0           | 0             | 0             |
| Country 2  | 0           | 0             | 0             |
| Country 1  | 0           | 0             | 0             |

Output

[
  {"country":"Country 1","gold_medals":0,"silver_medals":0,"bronze_medals":0},
  {"country":"Country 10","gold_medals":0,"silver_medals":0,"bronze_medals":0},
  {"country":"Country 2","gold_medals":0,"silver_medals":0,"bronze_medals":0}
]

Explanation

With full medal ties, lexicographic string order decides the final ranking.

Constraints

0 <= number of rows in MedalStandings <= 20000
country values are unique
1 <= length(country) <= 64
0 <= gold_medals <= 100000
0 <= silver_medals <= 100000
0 <= bronze_medals <= 100000
Every row must appear in the result exactly once
Sort priority is gold desc, silver desc, bronze desc, country asc
Country comparison uses standard lexicographic string order
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: country, gold_medals, silver_medals, bronze_medals

Preparing your editor. You can read the problem while it loads.

Medal Table Ranking with Cascading Tie-Breakers

Easy

An international sports analytics desk stores medal counts by country and needs a deterministic leaderboard for publishing and downstream reporting. Table: MedalStandings country: unique country name gold_medals: number of gold medals won silver_medals: number of silver medals won bronze_medals: number of bronze medals won Task: Return the same rows sorted by ranking priority: higher gold_medals first if tied, higher silver_medals first if tied, higher bronze_medals first if still tied, country ascending lexicographically Output requirements: Return exactly these columns: country, gold_medals, silver_medals, bronze_medals All rows must appear exactly once Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

MedalStandings:
| country     | gold_medals | silver_medals | bronze_medals |
|-------------|-------------|---------------|---------------|
| China       | 10          | 10            | 20            |
| South Sudan | 0           | 0             | 1             |
| USA         | 10          | 10            | 20            |
| Israel      | 2           | 2             | 3             |
| Egypt       | 2           | 2             | 2             |

Output

[
  {"country":"China","gold_medals":10,"silver_medals":10,"bronze_medals":20},
  {"country":"USA","gold_medals":10,"silver_medals":10,"bronze_medals":20},
  {"country":"Israel","gold_medals":2,"silver_medals":2,"bronze_medals":3},
  {"country":"Egypt","gold_medals":2,"silver_medals":2,"bronze_medals":2},
  {"country":"South Sudan","gold_medals":0,"silver_medals":0,"bronze_medals":1}
]

Explanation

China and USA tie on all medal counts, so country name breaks the tie. Israel beats Egypt on bronze medals after gold and silver ties.

Example 2

Input

MedalStandings:
| country     | gold_medals | silver_medals | bronze_medals |
|-------------|-------------|---------------|---------------|
| Aland       | 5           | 4             | 3             |
| Borealis    | 5           | 4             | 3             |
| Cyrenia     | 5           | 4             | 2             |
| Dalmora     | 6           | 0             | 0             |
| Estoria     | 5           | 5             | 0             |

Output

[
  {"country":"Dalmora","gold_medals":6,"silver_medals":0,"bronze_medals":0},
  {"country":"Estoria","gold_medals":5,"silver_medals":5,"bronze_medals":0},
  {"country":"Aland","gold_medals":5,"silver_medals":4,"bronze_medals":3},
  {"country":"Borealis","gold_medals":5,"silver_medals":4,"bronze_medals":3},
  {"country":"Cyrenia","gold_medals":5,"silver_medals":4,"bronze_medals":2}
]

Explanation

The ranking cascade applies left to right: gold, then silver, then bronze, then country.

Example 3

Input

MedalStandings:
| country    | gold_medals | silver_medals | bronze_medals |
|------------|-------------|---------------|---------------|
| Country 10 | 0           | 0             | 0             |
| Country 2  | 0           | 0             | 0             |
| Country 1  | 0           | 0             | 0             |

Output

[
  {"country":"Country 1","gold_medals":0,"silver_medals":0,"bronze_medals":0},
  {"country":"Country 10","gold_medals":0,"silver_medals":0,"bronze_medals":0},
  {"country":"Country 2","gold_medals":0,"silver_medals":0,"bronze_medals":0}
]

Explanation

With full medal ties, lexicographic string order decides the final ranking.

Constraints

0 <= number of rows in MedalStandings <= 20000
country values are unique
1 <= length(country) <= 64
0 <= gold_medals <= 100000
0 <= silver_medals <= 100000
0 <= bronze_medals <= 100000
Every row must appear in the result exactly once
Sort priority is gold desc, silver desc, bronze desc, country asc
Country comparison uses standard lexicographic string order
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: country, gold_medals, silver_medals, bronze_medals