DISTINCT to enumerate categorical values
Before any rules go live, I need the definitive channel list. Give me every distinct `channel` that appears in `aml_transactions`. Just the one column. Raw values — don't normalize, I want to see exactly how they're stored.
| Column | Type | Key |
|---|---|---|
| txn_id | INT | PK |
| account_id | INT | FK → aml_accounts |
| posted_date | TEXT | |
| posted_ts | TEXT | |
| amount | REAL | |
| channel | TEXT | |
| counterparty_name | TEXT | |
| counterparty_account_id | INT | |
| is_reversal | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Channels repeat across thousands of transaction rows — you want the unique list, not a count. Think about the SQL keyword that returns only distinct values.
Do NOT apply `LOWER()` or `TRIM()` — Aisha wants the raw stored values so we can spot casing drift from a source-system mismatch.
DISTINCT collapses thousands of transaction rows down to the unique channel taxonomy. The list is short — that's the point.