Top Percentile Fraud
[]
['Create table If Not Exists Fraud (policy_id int, state varchar(50), fraud_score decimal(5,2))', 'Truncate table Fraud', "insert into Fraud (policy_id, state, fraud_score) values ('1', 'California', '0.92')", "insert into Fraud (policy_id, state, fraud_score) values ('2', 'California', '0.68')", "insert into Fraud (policy_id, state, fraud_score) values ('3', 'California', '0.17')", "insert into Fraud (policy_id, state, fraud_score) values ('4', 'New York', '0.94')", "insert into Fraud (policy_id, state, fraud_score) values ('5', 'New York', '0.81')", "insert into Fraud (policy_id, state, fraud_score) values ('6', 'New York', '0.77')", "insert into Fraud (policy_id, state, fraud_score) values ('7', 'Texas', '0.98')", "insert into Fraud (policy_id, state, fraud_score) values ('8', 'Texas', '0.97')", "insert into Fraud (policy_id, state, fraud_score) values ('9', 'Texas', '0.96')", "insert into Fraud (policy_id, state, fraud_score) values ('10', 'Florida', '0.97')", "insert into Fraud (policy_id, state, fraud_score) values ('11', 'Florida', '0.98')", "insert into Fraud (policy_id, state, fraud_score) values ('12', 'Florida', '0.78')", "insert into Fraud (policy_id, state, fraud_score) values ('13', 'Florida', '0.88')", "insert into Fraud (policy_id, state, fraud_score) values ('14', 'Florida', '0.66')"]
{"mysql": ["Create table If Not Exists Fraud (policy_id int, state varchar(50), fraud_score decimal(5,2))"], "mssql": ["Create table  Fraud (policy_id int, state varchar(50), fraud_score decimal(5,2))"], "oraclesql": ["Create table Fraud (policy_id int, state varchar(50), fraud_score decimal(10,2))"], "database": true, "name": "top_percentile_fraud", "pythondata": ["Fraud = pd.DataFrame([], columns=['policy_id', 'state', 'fraud_score']).astype({'policy_id':'Int64', 'state':'object', 'fraud_score':'Float64'})\n"], "postgresql": ["Create table If Not Exists Fraud (policy_id int, state varchar(50), fraud_score decimal(5,2))\n"], "database_schema": {"Fraud": {"policy_id": "INT", "state": "VARCHAR(50)", "fraud_score": "DECIMAL(5, 2)"}}}
{"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']