Employees Project Allocation
[]
['Create table If Not Exists Project (project_id int, employee_id int, workload int)', 'Create table If Not Exists Employees (employee_id int, name varchar(20), team varchar(20))', 'Truncate table Project', "insert into Project (project_id, employee_id, workload) values ('1', '1', '45')", "insert into Project (project_id, employee_id, workload) values ('1', '2', '90')", "insert into Project (project_id, employee_id, workload) values ('2', '3', '12')", "insert into Project (project_id, employee_id, workload) values ('2', '4', '68')", 'Truncate table Employees', "insert into Employees (employee_id, name, team) values ('1', 'Khaled', 'A')", "insert into Employees (employee_id, name, team) values ('2', 'Ali', 'B')", "insert into Employees (employee_id, name, team) values ('3', 'John', 'B')", "insert into Employees (employee_id, name, team) values ('4', 'Doe', 'A')"]
{"mysql": ["Create table If Not Exists Project (project_id int, employee_id int, workload int)", "Create table If Not Exists Employees (employee_id int, name varchar(20), team varchar(20))"], "mssql": ["Create table Project (project_id int, employee_id int, workload int)", "Create table Employees (employee_id int, name varchar(20), team varchar(20))"], "oraclesql": ["Create table Project (project_id int, employee_id int, workload int)", "Create table Employees (employee_id int, name varchar(20), team varchar(20))"], "database": true, "name": "employees_with_above_avg_workload", "pythondata": ["Project = pd.DataFrame([], columns=['project_id', 'employee_id', 'workload']).astype({'project_id':'Int64', 'employee_id':'Int64', 'workload':'Int64'})\n", "Employees = pd.DataFrame([], columns=['employee_id', 'name', 'team']).astype({'employee_id':'Int64', 'name':'object', 'team':'object'})"], "postgresql": ["CREATE TABLE Project (\n    project_id int,\n    employee_id int,\n    workload int\n);", "CREATE TABLE Employees (\n    employee_id int,\n    name varchar(20),\n    team varchar(20)\n);"], "database_schema": {"Project": {"project_id": "INT", "employee_id": "INT", "workload": "INT"}, "Employees": {"employee_id": "INT", "name": "VARCHAR(20)", "team": "VARCHAR(20)"}}}
{"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']