Students With Invalid Departments
[]
['Create table If Not Exists Departments (id int, name varchar(30))', 'Create table If Not Exists Students (id int, name varchar(30), department_id int)', 'Truncate table Departments', "insert into Departments (id, name) values ('1', 'Electrical Engineering')", "insert into Departments (id, name) values ('7', 'Computer Engineering')", "insert into Departments (id, name) values ('13', 'Bussiness Administration')", 'Truncate table Students', "insert into Students (id, name, department_id) values ('23', 'Alice', '1')", "insert into Students (id, name, department_id) values ('1', 'Bob', '7')", "insert into Students (id, name, department_id) values ('5', 'Jennifer', '13')", "insert into Students (id, name, department_id) values ('2', 'John', '14')", "insert into Students (id, name, department_id) values ('4', 'Jasmine', '77')", "insert into Students (id, name, department_id) values ('3', 'Steve', '74')", "insert into Students (id, name, department_id) values ('6', 'Luis', '1')", "insert into Students (id, name, department_id) values ('8', 'Jonathan', '7')", "insert into Students (id, name, department_id) values ('7', 'Daiana', '33')", "insert into Students (id, name, department_id) values ('11', 'Madelynn', '1')"]
{"mysql": ["Create table If Not Exists Departments (id int, name varchar(30))", "Create table If Not Exists Students (id int, name varchar(30), department_id int)"], "mssql": ["Create table Departments (id int, name varchar(30))", "Create table Students (id int, name varchar(30), department_id int)"], "oraclesql": ["Create table Departments (id int, name varchar(30))", "Create table Students (id int, name varchar(30), department_id int)"], "database": true, "name": "find_students", "pythondata": ["Departments = pd.DataFrame([], columns=['id', 'name']).astype({'id':'Int64', 'name':'object'})", "Students = pd.DataFrame([], columns=['id', 'name', 'department_id']).astype({'id':'Int64', 'name':'object', 'department_id':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Departments (id int, name varchar(30))\n", "Create table If Not Exists Students (id int, name varchar(30), department_id int)"], "database_schema": {"Departments": {"id": "INT", "name": "VARCHAR(30)"}, "Students": {"id": "INT", "name": "VARCHAR(30)", "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']