Running Total for Different Genders — LeetCode 1308 Python Solution

Table: Scores +---------------+---------+ | Column Name | Type | +---------------+---------+ | player_name | varchar | | gender | varchar | | day | date | | score_points | int | +---------------+---------+ (gender, day) is the primary key (combination of columns with unique values) for this table. A competition is held between the female team and the male team.

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| player_name   | varchar |
| gender        | varchar |
| day           | date    |
| score_points  | int     |
+---------------+---------+
(gender, day) is the primary key (combination of columns with unique values) for this table.
A competition is held between the female team and the male team.
Each row of this table indicates that a player_name and with gender has scored score_point in someday.
Gender is 'F' if the player is in the female team and 'M' if the player is in the male team.

import duckdb
import pandas as pd

def solution(scores: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Scores", scores)
    return con.execute("""SELECT
    gender,
    day,
    SUM(score_points) OVER (
        PARTITION BY gender
        ORDER BY gender, day
    ) AS total
FROM Scores;""").df()