Count Artist Occurrences On Spotify Ranking List — LeetCode 2669 Python Solution

Table: Spotify +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | track_name | varchar | | artist | varchar | +-------------+---------+ id is the primary key (column with unique values) for this table. Each row contains an id, track_name, and artist.

+-------------+---------+ 
| Column Name | Type    | 
+-------------+---------+ 
| id          | int     | 
| track_name  | varchar |
| artist      | varchar |
+-------------+---------+
id is the primary key (column with unique values) for this table.
Each row contains an id, track_name, and artist.

import duckdb
import pandas as pd

# Pass input tables as keyword arguments matching the SQL table names.
def solution(**tables) -> pd.DataFrame:
    con = duckdb.connect()
    for name, df in tables.items():
        con.register(name, df)
    return con.execute("""SELECT
    artist,
    COUNT(1) AS occurrences
FROM Spotify
GROUP BY artist
ORDER BY occurrences DESC, artist;""").df()