How to Detect Database Anomalies in Transaction Amounts in SQL

This query detects anomalies in transaction amounts by flagging any transaction more than two standard deviations from the average.

Use-case: The fraud detection team wants to identify suspicious transactions that may indicate fraudulent activity.