Calculate Salaries
[]
['Create table If Not Exists Salaries (company_id int, employee_id int, employee_name varchar(13), salary int)', 'Truncate table Salaries', "insert into Salaries (company_id, employee_id, employee_name, salary) values ('1', '1', 'Tony', '2000')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('1', '2', 'Pronub', '21300')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('1', '3', 'Tyrrox', '10800')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('2', '1', 'Pam', '300')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('2', '7', 'Bassem', '450')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('2', '9', 'Hermione', '700')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('3', '7', 'Bocaben', '100')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('3', '2', 'Ognjen', '2200')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('3', '13', 'Nyancat', '3300')", "insert into Salaries (company_id, employee_id, employee_name, salary) values ('3', '15', 'Morninngcat', '7777')"]
{"mysql": ["Create table If Not Exists Salaries (company_id int, employee_id int, employee_name varchar(13), salary int)"], "mssql": ["Create table Salaries (company_id int, employee_id int, employee_name varchar(13), salary int)"], "oraclesql": ["Create table Salaries (company_id int, employee_id int, employee_name varchar(13), salary int)"], "database": true, "name": "calculate_salaries", "pythondata": ["Salaries = pd.DataFrame([], columns=['company_id', 'employee_id', 'employee_name', 'salary']).astype({'company_id':'Int64', 'employee_id':'Int64', 'employee_name':'object', 'salary':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Salaries (company_id int, employee_id int, employee_name varchar(13), salary int)"], "database_schema": {"Salaries": {"company_id": "INT", "employee_id": "INT", "employee_name": "VARCHAR(13)", "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']