Grand Slam Titles — LeetCode 1783 Python Solution

Table: Players +----------------+---------+ | Column Name | Type | +----------------+---------+ | player_id | int | | player_name | varchar | +----------------+---------+ player_id is the primary key (column with unique values) for this table. Each row in this table contains the name and the ID of a tennis player.

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| player_id      | int     |
| player_name    | varchar |
+----------------+---------+
player_id is the primary key (column with unique values) for this table.
Each row in this table contains the name and the ID of a tennis player.

import duckdb
import pandas as pd

def solution(players: pd.DataFrame, championships: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Players", players)
    con.register("Championships", championships)
    return con.execute("""WITH
    T AS (
        SELECT Wimbledon AS player_id
        FROM Championships
        UNION ALL
        SELECT Fr_open AS player_id
        FROM Championships
        UNION ALL
        SELECT US_open AS player_id
        FROM Championships
        UNION ALL
        SELECT Au_open AS player_id
        FROM Championships
    )
SELECT player_id, player_name, COUNT(1) AS grand_slams_count
FROM
    T
    JOIN Players USING (player_id)
GROUP BY 1;""").df()