SQL patterns I use to catch transaction fraud

Six SQL patterns I use to catch transaction fraud Quick disclaimer: I do data work on a program-integrity team. Examples below use generic transaction tables and made-up scenarios. Nothing here comes from anything I’ve actually worked on or seen. Views are mine, not my employer’s. Fraud detection in transaction data is mostly SQL. Not machine learning, not graph databases, not whatever Gartner is ...