Last updated on October 5th, 2024 at 04:37 pm

This Leetcode problem **Running Total for Different Genders LeetCode Solution** is done in SQL.

*List of all LeetCode Solution*

*List of all LeetCode Solution*

## Level of Question

Medium

**Running Total for Different Genders LeetCode Solution**

## Table of Contents

**Problem Statement**

Column Name | Type |

player_name | varchar |

gender | varchar |

day | date |

score_points | int |

**Table: Scores**

(gender, day) is the primary key for this table.

A competition is held between females team and males 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 females team and ‘M’ if the player is in males team.

**Write an SQL query to find the total score for each gender at each day. Order the result table by gender and day.**

The result format is in the following example.

**Example 1:Input:**

player_name | gender | day | score_points |

Aron | F | 2020-01-01 | 17 |

Alice | F | 2020-01-07 | 23 |

Bajrang | M | 2020-01-07 | 7 |

Khali | M | 2019-12-25 | 11 |

Slaman | M | 2019-12-30 | 13 |

Joe | M | 2019-12-31 | 3 |

Jose | M | 2019-12-18 | 2 |

Priya | F | 2019-12-31 | 23 |

Priyanka | F | 2019-12-30 | 17 |

**Scores table:**

**Output:**

gender | day | total |

F | 2019-12-30 | 17 |

F | 2019-12-31 | 40 |

F | 2020-01-01 | 57 |

F | 2020-01-07 | 80 |

M | 2019-12-18 | 2 |

M | 2019-12-25 | 13 |

M | 2019-12-30 | 26 |

M | 2019-12-31 | 29 |

M | 2020-01-07 | 36 |

Explanation:

For females team:

First day is 2019-12-30, Priyanka scored 17 points and the total score for the team is 17.

Second day is 2019-12-31, Priya scored 23 points and the total score for the team is 40.

Third day is 2020-01-01, Aron scored 17 points and the total score for the team is 57.

Fourth day is 2020-01-07, Alice scored 23 points and the total score for the team is 80.

For males team:

First day is 2019-12-18, Jose scored 2 points and the total score for the team is 2.

Second day is 2019-12-25, Khali scored 11 points and the total score for the team is 13.

Third day is 2019-12-30, Slaman scored 13 points and the total score for the team is 26.

Fourth day is 2019-12-31, Joe scored 3 points and the total score for the team is 29.

Fifth day is 2020-01-07, Bajrang scored 7 points and the total score for the team is 36.

**1. Running Total for Different Genders LeetCode Solution MySQL**

select s1.gender, s1.day, sum(s2.score_points) as total from Scores as s1 join Scores as s2 on s1.gender = s2.gender and s1.day >= s2.day group by s1.gender, s1.day order by gender, day;