DISTINCT to find unique values in a column
Before any of the segmentation work, I need the canonical product list. Give me every distinct `subcategory` that appears in `retail_products`. One column. Raw values — don't normalize, I want to see the casing as it's actually stored in case there's drift from the core.
| Column | Type | Key |
|---|---|---|
| product_id | INT | PK |
| product_code | TEXT | |
| product_name | TEXT | |
| category | TEXT | |
| subcategory | TEXT | |
| default_apr | REAL | |
| default_apy | REAL | |
| monthly_fee | REAL | |
| nsf_fee | REAL | |
| od_fee | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
Subcategories repeat across the product table — you want the unique list, not a count. Think about the SQL keyword that returns only distinct values.
Do NOT apply `LOWER()` or `TRIM()` — Marcus wants the raw stored values to spot any casing drift from the core banking system.
DISTINCT collapses repeats down to the unique product taxonomy. The list is short — that's the point of running it.