Accepted Candidates From the Interviews
[]
['Create table If Not Exists Candidates (candidate_id int, name varchar(30), years_of_exp int, interview_id int)', 'Create table If Not Exists Rounds (interview_id int, round_id int, score int)', 'Truncate table Candidates', "insert into Candidates (candidate_id, name, years_of_exp, interview_id) values ('11', 'Atticus', '1', '101')", "insert into Candidates (candidate_id, name, years_of_exp, interview_id) values ('9', 'Ruben', '6', '104')", "insert into Candidates (candidate_id, name, years_of_exp, interview_id) values ('6', 'Aliza', '10', '109')", "insert into Candidates (candidate_id, name, years_of_exp, interview_id) values ('8', 'Alfredo', '0', '107')", 'Truncate table Rounds', "insert into Rounds (interview_id, round_id, score) values ('109', '3', '4')", "insert into Rounds (interview_id, round_id, score) values ('101', '2', '8')", "insert into Rounds (interview_id, round_id, score) values ('109', '4', '1')", "insert into Rounds (interview_id, round_id, score) values ('107', '1', '3')", "insert into Rounds (interview_id, round_id, score) values ('104', '3', '6')", "insert into Rounds (interview_id, round_id, score) values ('109', '1', '4')", "insert into Rounds (interview_id, round_id, score) values ('104', '4', '7')", "insert into Rounds (interview_id, round_id, score) values ('104', '1', '2')", "insert into Rounds (interview_id, round_id, score) values ('109', '2', '1')", "insert into Rounds (interview_id, round_id, score) values ('104', '2', '7')", "insert into Rounds (interview_id, round_id, score) values ('107', '2', '3')", "insert into Rounds (interview_id, round_id, score) values ('101', '1', '8')"]
{"mysql": ["Create table If Not Exists Candidates (candidate_id int, name varchar(30), years_of_exp int, interview_id int)", "Create table If Not Exists Rounds (interview_id int, round_id int, score int)"], "mssql": ["Create table Candidates (candidate_id int, name varchar(30), years_of_exp int, interview_id int)", "Create table Rounds (interview_id int, round_id int, score int)"], "oraclesql": ["Create table Candidates (candidate_id int, name varchar(30), years_of_exp int, interview_id int)", "Create table Rounds (interview_id int, round_id int, score int)"], "database": true, "name": "accepted_candidates", "pythondata": ["Candidates = pd.DataFrame([], columns=['candidate_id', 'name', 'years_of_exp', 'interview_id']).astype({'candidate_id':'Int64', 'name':'object', 'years_of_exp':'Int64', 'interview_id':'Int64'})", "Rounds = pd.DataFrame([], columns=['interview_id', 'round_id', 'score']).astype({'interview_id':'Int64', 'round_id':'Int64', 'score':'Int64'})"], "postgresql": ["Create table If Not Exists Candidates (candidate_id int, name varchar(30), years_of_exp int, interview_id int)", "Create table If Not Exists Rounds (interview_id int, round_id int, score int)"], "database_schema": {"Candidates": {"candidate_id": "INT", "name": "VARCHAR(30)", "years_of_exp": "INT", "interview_id": "INT"}, "Rounds": {"interview_id": "INT", "round_id": "INT", "score": "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']