Count Apples and Oranges
[]
['Create table If Not Exists Boxes (box_id int, chest_id int, apple_count int, orange_count int)', 'Create table If Not Exists Chests (chest_id int, apple_count int, orange_count int)', 'Truncate table Boxes', "insert into Boxes (box_id, chest_id, apple_count, orange_count) values ('2', NULL, '6', '15')", "insert into Boxes (box_id, chest_id, apple_count, orange_count) values ('18', '14', '4', '15')", "insert into Boxes (box_id, chest_id, apple_count, orange_count) values ('19', '3', '8', '4')", "insert into Boxes (box_id, chest_id, apple_count, orange_count) values ('12', '2', '19', '20')", "insert into Boxes (box_id, chest_id, apple_count, orange_count) values ('20', '6', '12', '9')", "insert into Boxes (box_id, chest_id, apple_count, orange_count) values ('8', '6', '9', '9')", "insert into Boxes (box_id, chest_id, apple_count, orange_count) values ('3', '14', '16', '7')", 'Truncate table Chests', "insert into Chests (chest_id, apple_count, orange_count) values ('6', '5', '6')", "insert into Chests (chest_id, apple_count, orange_count) values ('14', '20', '10')", "insert into Chests (chest_id, apple_count, orange_count) values ('2', '8', '8')", "insert into Chests (chest_id, apple_count, orange_count) values ('3', '19', '4')", "insert into Chests (chest_id, apple_count, orange_count) values ('16', '19', '19')"]
{"mysql": ["Create table If Not Exists Boxes (box_id int, chest_id int, apple_count int, orange_count int)", "Create table If Not Exists Chests (chest_id int, apple_count int, orange_count int)"], "mssql": ["Create table Boxes (box_id int, chest_id int, apple_count int, orange_count int)", "Create table Chests (chest_id int, apple_count int, orange_count int)"], "oraclesql": ["Create table Boxes (box_id int, chest_id int, apple_count int, orange_count int)", "Create table Chests (chest_id int, apple_count int, orange_count int)"], "database": true, "name": "count_apples_and_oranges", "pythondata": ["Boxes = pd.DataFrame([], columns=['box_id', 'chest_id', 'apple_count', 'orange_count']).astype({'box_id':'Int64', 'chest_id':'Int64', 'apple_count':'Int64', 'orange_count':'Int64'})", "Chests = pd.DataFrame([], columns=['chest_id', 'apple_count', 'orange_count']).astype({'chest_id':'Int64', 'apple_count':'Int64', 'orange_count':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Boxes (box_id int, chest_id int, apple_count int, orange_count int)\n", "Create table If Not Exists Chests (chest_id int, apple_count int, orange_count int)"], "database_schema": {"Boxes": {"box_id": "INT", "chest_id": "INT", "apple_count": "INT", "orange_count": "INT"}, "Chests": {"chest_id": "INT", "apple_count": "INT", "orange_count": "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']