Find Cumulative Salary of an Employee
[]
['Create table If Not Exists Employee (id int, month int, salary int)', 'Truncate table Employee', "insert into Employee (id, month, salary) values ('1', '1', '20')", "insert into Employee (id, month, salary) values ('2', '1', '20')", "insert into Employee (id, month, salary) values ('1', '2', '30')", "insert into Employee (id, month, salary) values ('2', '2', '30')", "insert into Employee (id, month, salary) values ('3', '2', '40')", "insert into Employee (id, month, salary) values ('1', '3', '40')", "insert into Employee (id, month, salary) values ('3', '3', '60')", "insert into Employee (id, month, salary) values ('1', '4', '60')", "insert into Employee (id, month, salary) values ('3', '4', '70')", "insert into Employee (id, month, salary) values ('1', '7', '90')", "insert into Employee (id, month, salary) values ('1', '8', '90')"]
{"mysql": ["Create table If Not Exists Employee (id int, month int, salary int)"], "mssql": ["Create table Employee (id int, month int, salary int)"], "oraclesql": ["Create table Employee (id int, month int, salary int)"], "database": true, "name": "cumulative_salary", "pythondata": ["Employee = pd.DataFrame([], columns=['id', 'month', 'salary']).astype({'id':'Int64', 'month':'Int64', 'salary':'Int64'})\n"], "postgresql": ["\nCreate table If Not Exists Employee (id int, month int, salary int)"], "database_schema": {"Employee": {"id": "INT", "month": "INT", "salary": "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']