Friday Purchases I
[]
['Create Table if Not Exists Purchases( user_id int, purchase_date date, amount_spend int)', 'Truncate table Purchases', "insert into Purchases (user_id, purchase_date, amount_spend) values ('11', '2023-11-07', '1126')", "insert into Purchases (user_id, purchase_date, amount_spend) values ('15', '2023-11-30', '7473')", "insert into Purchases (user_id, purchase_date, amount_spend) values ('17', '2023-11-14', '2414')", "insert into Purchases (user_id, purchase_date, amount_spend) values ('12', '2023-11-24', '9692')", "insert into Purchases (user_id, purchase_date, amount_spend) values ('8', '2023-11-03', '5117')", "insert into Purchases (user_id, purchase_date, amount_spend) values ('1', '2023-11-16', '5241')", "insert into Purchases (user_id, purchase_date, amount_spend) values ('10', '2023-11-12', '8266')", "insert into Purchases (user_id, purchase_date, amount_spend) values ('13', '2023-11-24', '12000')"]
{"mysql": ["Create Table if Not Exists Purchases( user_id int, purchase_date date, amount_spend int)"], "mssql": ["Create Table Purchases( user_id int, purchase_date date, amount_spend int)"], "oraclesql": ["Create Table  Purchases( user_id int, purchase_date date, amount_spend int)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD'"], "database": true, "name": "friday_purchases", "pythondata": ["Purchases = pd.DataFrame([], columns=['user_id', 'purchase_date', 'amount_spend']).astype({'user_id':'Int64', 'purchase_date':'datetime64[ns]', 'amount_spend':'Int64'})\n"], "postgresql": ["Create Table if Not Exists Purchases( user_id int, purchase_date date, amount_spend int)"], "database_schema": {"Purchases": {"user_id": "INT", "purchase_date": "DATE", "amount_spend": "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']