Winning Candidate
[]
['Create table If Not Exists Candidate (id int, name varchar(255))', 'Create table If Not Exists Vote (id int, candidateId int)', 'Truncate table Candidate', "insert into Candidate (id, name) values ('1', 'A')", "insert into Candidate (id, name) values ('2', 'B')", "insert into Candidate (id, name) values ('3', 'C')", "insert into Candidate (id, name) values ('4', 'D')", "insert into Candidate (id, name) values ('5', 'E')", 'Truncate table Vote', "insert into Vote (id, candidateId) values ('1', '2')", "insert into Vote (id, candidateId) values ('2', '4')", "insert into Vote (id, candidateId) values ('3', '3')", "insert into Vote (id, candidateId) values ('4', '2')", "insert into Vote (id, candidateId) values ('5', '5')"]
{"mysql": ["Create table If Not Exists Candidate (id int, name varchar(255))", "Create table If Not Exists Vote (id int, candidateId int)"], "mssql": ["Create table Candidate (id int, name varchar(255))", "Create table Vote (id int, candidateId int)"], "oraclesql": ["Create table Candidate (id int, name varchar(255))", "Create table Vote (id int, candidateId int)"], "database": true, "name": "winning_candidate", "pythondata": ["Candidate = pd.DataFrame([], columns=['id', 'name']).astype({'id':'Int64', 'name':'object'})", "Vote = pd.DataFrame([], columns=['id', 'candidateId']).astype({'id':'Int64', 'candidateId':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Candidate (id int, name varchar(255))\n", "Create table If Not Exists Vote (id int, candidateId int)"], "database_schema": {"Candidate": {"id": "INT", "name": "VARCHAR(255)"}, "Vote": {"id": "INT", "candidateId": "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']