Project Employees II
['project-employees-i', 'project-employees-iii']
['Create table If Not Exists Project (project_id int, employee_id int)', 'Create table If Not Exists Employee (employee_id int, name varchar(10), experience_years int)', 'Truncate table Project', "insert into Project (project_id, employee_id) values ('1', '1')", "insert into Project (project_id, employee_id) values ('1', '2')", "insert into Project (project_id, employee_id) values ('1', '3')", "insert into Project (project_id, employee_id) values ('2', '1')", "insert into Project (project_id, employee_id) values ('2', '4')", 'Truncate table Employee', "insert into Employee (employee_id, name, experience_years) values ('1', 'Khaled', '3')", "insert into Employee (employee_id, name, experience_years) values ('2', 'Ali', '2')", "insert into Employee (employee_id, name, experience_years) values ('3', 'John', '1')", "insert into Employee (employee_id, name, experience_years) values ('4', 'Doe', '2')"]
{"mysql": ["Create table If Not Exists Project (project_id int, employee_id int)", "Create table If Not Exists Employee (employee_id int, name varchar(10), experience_years int)"], "mssql": ["Create table Project (project_id int, employee_id int)", "Create table Employee (employee_id int, name varchar(10), experience_years int)"], "oraclesql": ["Create table Project (project_id int, employee_id int)", "Create table Employee (employee_id int, name varchar(10), experience_years int)"], "database": true, "name": "project_employees_ii", "pythondata": ["Project = pd.DataFrame([], columns=['project_id', 'employee_id']).astype({'project_id':'Int64', 'employee_id':'Int64'})", "Employee = pd.DataFrame([], columns=['employee_id', 'name', 'experience_years']).astype({'employee_id':'Int64', 'name':'object', 'experience_years':'Int64'})"], "database_schema": {"Project": {"project_id": "INT", "employee_id": "INT"}, "Employee": {"employee_id": "INT", "name": "VARCHAR(10)", "experience_years": "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>"]}
['Database']