SQL Lab: Retail Banking Accounts and Loans (synthetic)
About 3,000 invented customers with accounts, tens of thousands of transactions, fraud flags and a loan book over two years.
Meridian Bank is an invented retail bank with 20 branches in five regions. The leadership team wants one view of customer growth, product mix, channel use (branch versus app), fraud flags and the health of the loan book. The data contains no names, account numbers or identity numbers. Everything is generated by a seeded script, with realistic shapes such as many small card purchases, fewer large deposits, higher fraud flags on large card purchases and loan arrears that depend on income and loan type.
Write SQL on this sample data and see the results. It runs in your browser with SQLite, so it is not SQL Server, MySQL or PostgreSQL.