Legal Ops & ComplianceHard
Detect potential structuring with SQL.
Seen at: Chime · Coinbase · JPMorgan
Write SQL that flags customers who may be structuring cash deposits — making multiple deposits just below $10,000 within a short window to evade CTR reporting. You have deposits(customer_id, deposit_ts, amount_usd, channel).
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Stuck? Peek at a hint
Reveals the model answer and the self-score rubric.