Bank Account Summary
[]
['Create table If Not Exists Users (user_id int, user_name varchar(20), credit int)\n', 'Create table If Not Exists Transactions (trans_id int, paid_by int, paid_to int, amount int, transacted_on date)', 'Truncate table Users', "insert into Users (user_id, user_name, credit) values ('1', 'Moustafa', '100')", "insert into Users (user_id, user_name, credit) values ('2', 'Jonathan', '200')", "insert into Users (user_id, user_name, credit) values ('3', 'Winston', '10000')", "insert into Users (user_id, user_name, credit) values ('4', 'Luis', '800')", 'Truncate table Transactions', "insert into Transactions (trans_id, paid_by, paid_to, amount, transacted_on) values ('1', '1', '3', '400', '2020-08-01')", "insert into Transactions (trans_id, paid_by, paid_to, amount, transacted_on) values ('2', '3', '2', '500', '2020-08-02')", "insert into Transactions (trans_id, paid_by, paid_to, amount, transacted_on) values ('3', '2', '1', '200', '2020-08-03')"]
{"mysql": ["Create table If Not Exists Users (user_id int, user_name varchar(20), credit int)\n", "Create table If Not Exists Transactions (trans_id int, paid_by int, paid_to int, amount int, transacted_on date)"], "mssql": ["Create table Users (user_id int, user_name varchar(20), credit int)\n", "Create table Transactions (trans_id int, paid_by int, paid_to int, amount int, transacted_on date)\n"], "oraclesql": ["Create table Users (user_id int, user_name varchar(20), credit int)\n", "Create table Transactions (trans_id int, paid_by int, paid_to int, amount int, transacted_on date)\n", "ALTER SESSION SET nls_date_format='YYYY-MM-DD'\n"], "database": true, "name": "bank_account_summary", "pythondata": ["Users = pd.DataFrame([], columns=['user_id', 'user_name', 'credit']).astype({'user_id':'Int64', 'user_name':'object', 'credit':'Int64'})", "Transactions = pd.DataFrame([], columns=['trans_id', 'paid_by', 'paid_to', 'amount', 'transacted_on']).astype({'trans_id':'Int64', 'paid_by':'Int64', 'paid_to':'Int64', 'amount':'Int64', 'transacted_on':'datetime64[ns]'})"], "postgresql": ["\nCreate table If Not Exists Users (user_id int, user_name varchar(20), credit int)\n", "Create table If Not Exists Transactions (trans_id int, paid_by int, paid_to int, amount int, transacted_on date)"], "database_schema": {"Users": {"user_id": "INT", "user_name": "VARCHAR(20)", "credit": "INT"}, "Transactions": {"trans_id": "INT", "paid_by": "INT", "paid_to": "INT", "amount": "INT", "transacted_on": "DATE"}}}
{"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']