Year on Year Growth Rate
[]
['Create Table if not exists user_transactions( transaction_id int, product_id int, spend decimal(10,2), \ntransaction_date datetime)', 'Truncate table user_transactions', "insert into user_transactions (transaction_id, product_id, spend, transaction_date) values ('1341', '123424', '1500.6', '2019-12-31 12:00:00')", "insert into user_transactions (transaction_id, product_id, spend, transaction_date) values ('1423', '123424', '1000.2', '2020-12-31 12:00:00')", "insert into user_transactions (transaction_id, product_id, spend, transaction_date) values ('1623', '123424', '1246.44', '2021-12-31 12:00:00')", "insert into user_transactions (transaction_id, product_id, spend, transaction_date) values ('1322', '123424', '2145.32', '2022-12-31 12:00:00')"]
{"mysql": ["Create Table if not exists user_transactions( transaction_id int, product_id int, spend decimal(10,2), \ntransaction_date datetime)"], "mssql": ["Create Table  user_transactions( transaction_id int, product_id int, spend decimal(10,2), \ntransaction_date datetime)"], "oraclesql": ["Create Table  user_transactions( transaction_id NUMBER, product_id NUMBER, spend NUMBER(10,2), \ntransaction_date date)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD HH24:MI:SS'"], "database": true, "name": "calculate_yoy_growth", "postgresql": ["CREATE TABLE IF NOT EXISTS user_transactions (\n    transaction_id INT,\n    product_id INT,\n    spend NUMERIC(10, 2),\n    transaction_date TIMESTAMP\n);\n"], "pythondata": ["user_transactions = pd.DataFrame(columns=['transaction_id', 'product_id', 'spend', 'transaction_date']).astype({'transaction_id': 'int','product_id': 'int','spend': 'float','transaction_date': 'datetime64[ns]'})\n"], "database_schema": {"user_transactions": {"transaction_id": "INT", "product_id": "INT", "spend": "DECIMAL(10, 2)", "transaction_date": "DATETIME"}}}
{"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']