Average Salary: Departments VS Company
['countries-you-can-safely-invest-in']
['Create table If Not Exists Salary (id int, employee_id int, amount int, pay_date date)', 'Create table If Not Exists Employee (employee_id int, department_id int)', 'Truncate table Salary', "insert into Salary (id, employee_id, amount, pay_date) values ('1', '1', '9000', '2017/03/31')", "insert into Salary (id, employee_id, amount, pay_date) values ('2', '2', '6000', '2017/03/31')", "insert into Salary (id, employee_id, amount, pay_date) values ('3', '3', '10000', '2017/03/31')", "insert into Salary (id, employee_id, amount, pay_date) values ('4', '1', '7000', '2017/02/28')", "insert into Salary (id, employee_id, amount, pay_date) values ('5', '2', '6000', '2017/02/28')", "insert into Salary (id, employee_id, amount, pay_date) values ('6', '3', '8000', '2017/02/28')", 'Truncate table Employee', "insert into Employee (employee_id, department_id) values ('1', '1')", "insert into Employee (employee_id, department_id) values ('2', '2')", "insert into Employee (employee_id, department_id) values ('3', '2')"]
{"mysql": ["Create table If Not Exists Salary (id int, employee_id int, amount int, pay_date date)", "Create table If Not Exists Employee (employee_id int, department_id int)"], "mssql": ["Create table Salary (id int, employee_id int, amount int, pay_date date)", "Create table Employee (employee_id int, department_id int)"], "oraclesql": ["Create table Salary (id int, employee_id int, amount int, pay_date date)", "Create table Employee (employee_id int, department_id int)", "alter SESSION set NLS_DATE_FORMAT = 'YYYY/MM/DD'"], "database": true, "name": "average_salary", "pythondata": ["Salary = pd.DataFrame([], columns=['id', 'employee_id', 'amount', 'pay_date']).astype({'id':'Int64', 'employee_id':'Int64', 'amount':'Int64', 'pay_date':'datetime64[ns]'})", "Employee = pd.DataFrame([], columns=['employee_id', 'department_id']).astype({'employee_id':'Int64', 'department_id':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Salary (id int, employee_id int, amount int, pay_date date)\n", "Create table If Not Exists Employee (employee_id int, department_id int)"], "database_schema": {"Salary": {"id": "INT", "employee_id": "INT", "amount": "INT", "pay_date": "DATE"}, "Employee": {"employee_id": "INT", "department_id": "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']