How would you use SQL to investigate data issues like false positives?
Use the provided transaction, fraud alert, and merchant data. Focus on reviewed alerts with a resolved outcome and identify merchant and alert-type combinations where at least half of reviewed alerts were false positives.
Output
- One row per qualifying merchant and alert type.
- Include
merchant_id, merchant_name, alert_type, reviewed_alerts, false_positive_count, and false_positive_rate_pct.
- Sort by false-positive rate descending, reviewed alert count descending, and merchant name ascending.
