How hard is LeetCode 2377. Sort the Olympic Table?

LeetCode 2377. Sort the Olympic Table is rated Easy on LeetCode.

What topics does LeetCode 2377. Sort the Olympic Table cover?

LeetCode 2377. Sort the Olympic Table is tagged Database on LeetCode.

Is LeetCode 2377. Sort the Olympic Table a premium problem?

Yes. LeetCode 2377. Sort the Olympic Table is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.

Sort the Olympic Table — LeetCode 2377 Python Solution

EasyLeetCode PremiumDatabase

Problem: #2377
Reading time: 2 min
Source: leetcode.com

Table schema

SQL

Table: Olympic +---------------+---------+ | Column Name | Type | +---------------+---------+ | country | varchar | | gold_medals | int | | silver_medals | int | | bronze_medals | int | +---------------+---------+ In SQL, country is the primary key for this table. Each row in this table shows a country name and the number of gold, silver, and bronze medals it won in the Olympic games.

Example

SQL

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| country       | varchar |
| gold_medals   | int     |
| silver_medals | int     |
| bronze_medals | int     |
+---------------+---------+
In SQL, country is the primary key for this table.
Each row in this table shows a country name and the number of gold, silver, and bronze medals it won in the Olympic games.

Python solution

Python

import duckdb
import pandas as pd

def solution(olympic: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Olympic", olympic)
    return con.execute("""SELECT *
FROM Olympic
ORDER BY 2 DESC, 3 DESC, 4 DESC, 1;""").df()

Complexity

Measure	Complexity
Time	O(n log n) (typical)
Space	O(n) auxiliary

Frequently asked questions

How hard is LeetCode 2377. Sort the Olympic Table?: LeetCode 2377. Sort the Olympic Table is rated Easy on LeetCode.
What topics does LeetCode 2377. Sort the Olympic Table cover?: LeetCode 2377. Sort the Olympic Table is tagged Database on LeetCode.
Is LeetCode 2377. Sort the Olympic Table a premium problem?: Yes. LeetCode 2377. Sort the Olympic Table is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.