Suspicious Bank Accounts
[]
['Create table If Not Exists Accounts (account_id int, max_income int)', "Create table If Not Exists Transactions (transaction_id int, account_id int, type ENUM('creditor', 'debtor'), amount int, day datetime)", 'Truncate table Accounts', "insert into Accounts (account_id, max_income) values ('3', '21000')", "insert into Accounts (account_id, max_income) values ('4', '10400')", 'Truncate table Transactions', "insert into Transactions (transaction_id, account_id, type, amount, day) values ('2', '3', 'Creditor', '107100', '2021-06-02 11:38:14')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('4', '4', 'Creditor', '10400', '2021-06-20 12:39:18')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('11', '4', 'Debtor', '58800', '2021-07-23 12:41:55')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('1', '4', 'Creditor', '49300', '2021-05-03 16:11:04')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('15', '3', 'Debtor', '75500', '2021-05-23 14:40:20')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('10', '3', 'Creditor', '102100', '2021-06-15 10:37:16')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('14', '4', 'Creditor', '56300', '2021-07-21 12:12:25')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('19', '4', 'Debtor', '101100', '2021-05-09 15:21:49')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('8', '3', 'Creditor', '64900', '2021-07-26 15:09:56')", "insert into Transactions (transaction_id, account_id, type, amount, day) values ('7', '3', 'Creditor', '90900', '2021-06-14 11:23:07')"]
{"mysql": ["Create table If Not Exists Accounts (account_id int, max_income int)", "Create table If Not Exists Transactions (transaction_id int, account_id int, type ENUM('creditor', 'debtor'), amount int, day datetime)"], "mssql": ["Create table Accounts (account_id int, max_income int)", "Create table Transactions (transaction_id int, account_id int, type varchar(8) NOT NULL CHECK (type IN('creditor', 'debtor')), amount int, day datetime)"], "oraclesql": ["Create table Accounts (account_id int, max_income int)", "Create table Transactions (transaction_id int, account_id int, type varchar(8) NOT NULL CHECK (type IN('Creditor', 'Debtor')), amount int, day date)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD HH24:MI:SS'"], "database": true, "name": "suspicious_bank_accounts", "pythondata": ["Accounts = pd.DataFrame([], columns=['account_id', 'max_income']).astype({'account_id':'Int64', 'max_income':'Int64'})", "Transactions = pd.DataFrame([], columns=['transaction_id', 'account_id', 'type', 'amount', 'day']).astype({'transaction_id':'Int64', 'account_id':'Int64', 'type':'object', 'amount':'Int64', 'day':'datetime64[ns]'})"], "postgresql": ["Create table If Not Exists Accounts (account_id int, max_income int)\n", "Create table If Not Exists Transactions (transaction_id int, account_id int, type VARCHAR(30) CHECK (type IN ('Creditor', 'Debtor')), amount int, day timestamp)\n\n"], "manual": false, "database_schema": {"Accounts": {"account_id": "INT", "max_income": "INT"}, "Transactions": {"transaction_id": "INT", "account_id": "INT", "type": "ENUM('creditor', 'debtor')", "amount": "INT", "day": "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']