Running Total for Different Genders
['last-person-to-fit-in-the-bus']
['Create table If Not Exists Scores (player_name varchar(20), gender varchar(1), day date, score_points int)', 'Truncate table Scores', "insert into Scores (player_name, gender, day, score_points) values ('Aron', 'F', '2020-01-01', '17')", "insert into Scores (player_name, gender, day, score_points) values ('Alice', 'F', '2020-01-07', '23')", "insert into Scores (player_name, gender, day, score_points) values ('Bajrang', 'M', '2020-01-07', '7')", "insert into Scores (player_name, gender, day, score_points) values ('Khali', 'M', '2019-12-25', '11')", "insert into Scores (player_name, gender, day, score_points) values ('Slaman', 'M', '2019-12-30', '13')", "insert into Scores (player_name, gender, day, score_points) values ('Joe', 'M', '2019-12-31', '3')", "insert into Scores (player_name, gender, day, score_points) values ('Jose', 'M', '2019-12-18', '2')", "insert into Scores (player_name, gender, day, score_points) values ('Priya', 'F', '2019-12-31', '23')", "insert into Scores (player_name, gender, day, score_points) values ('Priyanka', 'F', '2019-12-30', '17')"]
{"mysql": ["Create table If Not Exists Scores (player_name varchar(20), gender varchar(1), day date, score_points int)"], "mssql": ["Create table Scores (player_name varchar(20), gender varchar(1), day date, score_points int)"], "oraclesql": ["Create table Scores (player_name varchar(20), gender varchar(1), day date, score_points int)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD'"], "database": true, "name": "running_total", "pythondata": ["Scores = pd.DataFrame([], columns=['player_name', 'gender', 'day', 'score_points']).astype({'player_name':'object', 'gender':'object', 'day':'datetime64[ns]', 'score_points':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Scores (player_name varchar(20), gender varchar(1), day date, score_points int)"], "database_schema": {"Scores": {"player_name": "VARCHAR(20)", "gender": "VARCHAR(1)", "day": "DATE", "score_points": "INT"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']