Product's Worth Over Invoices
[]
['Create table If Not Exists Product(product_id int, name varchar(15))', 'Create table If Not Exists Invoice(invoice_id int,product_id int,rest int, paid int, canceled int, refunded int)', 'Truncate table Product', "insert into Product (product_id, name) values ('0', 'ham')", "insert into Product (product_id, name) values ('1', 'bacon')", 'Truncate table Invoice', "insert into Invoice (invoice_id, product_id, rest, paid, canceled, refunded) values ('23', '0', '2', '0', '5', '0')", "insert into Invoice (invoice_id, product_id, rest, paid, canceled, refunded) values ('12', '0', '0', '4', '0', '3')", "insert into Invoice (invoice_id, product_id, rest, paid, canceled, refunded) values ('1', '1', '1', '1', '0', '1')", "insert into Invoice (invoice_id, product_id, rest, paid, canceled, refunded) values ('2', '1', '1', '0', '1', '1')", "insert into Invoice (invoice_id, product_id, rest, paid, canceled, refunded) values ('3', '1', '0', '1', '1', '1')", "insert into Invoice (invoice_id, product_id, rest, paid, canceled, refunded) values ('4', '1', '1', '1', '1', '0')"]
{"mysql": ["Create table If Not Exists Product(product_id int, name varchar(15))", "Create table If Not Exists Invoice(invoice_id int,product_id int,rest int, paid int, canceled int, refunded int)"], "mssql": ["Create table Product(product_id int, name varchar(15))", "Create table Invoice(invoice_id int,product_id int,rest int, paid int, canceled int, refunded int)"], "oraclesql": ["Create table Product(product_id int, name varchar(15))", "Create table Invoice(invoice_id int,product_id int,rest int, paid int, canceled int, refunded int)"], "database": true, "name": "analyze_products", "pythondata": ["Product = pd.DataFrame([], columns=['product_id', 'name']).astype({'product_id':'Int64', 'name':'object'})", "Invoice = pd.DataFrame([], columns=['invoice_id', 'product_id', 'rest', 'paid', 'canceled', 'refunded']).astype({'invoice_id':'Int64', 'product_id':'Int64', 'rest':'Int64', 'paid':'Int64', 'canceled':'Int64', 'refunded':'Int64'})"], "postgresql": ["Create table If Not Exists Product(product_id int, name varchar(15))", "Create table If Not Exists Invoice(invoice_id int,product_id int,rest int, paid int, canceled int, refunded int)"], "database_schema": {"Product": {"product_id": "INT", "name": "VARCHAR(15)"}, "Invoice": {"invoice_id": "INT", "product_id": "INT", "rest": "INT", "paid": "INT", "canceled": "INT", "refunded": "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']