How hard is LeetCode 1308. Running Total for Different Genders?

LeetCode 1308. Running Total for Different Genders is rated Medium on LeetCode.

What topics does LeetCode 1308. Running Total for Different Genders cover?

LeetCode 1308. Running Total for Different Genders is tagged Database on LeetCode.

Is LeetCode 1308. Running Total for Different Genders a premium problem?

Yes. LeetCode 1308. Running Total for Different Genders is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.

Running Total for Different Genders — LeetCode 1308 Python Solution

MediumLeetCode PremiumDatabase

Problem: #1308
Reading time: 3 min
Source: leetcode.com

Table schema

SQL

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.

Example

SQL

+---------------+---------+
| 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.

Python solution

Python

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()

Complexity

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

Frequently asked questions

How hard is LeetCode 1308. Running Total for Different Genders?: LeetCode 1308. Running Total for Different Genders is rated Medium on LeetCode.
What topics does LeetCode 1308. Running Total for Different Genders cover?: LeetCode 1308. Running Total for Different Genders is tagged Database on LeetCode.
Is LeetCode 1308. Running Total for Different Genders a premium problem?: Yes. LeetCode 1308. Running Total for Different Genders is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.