DISTINCT — pull the unique values of a column.
I'm setting up the procurement dashboard categories. What categories do we have in `dim_skus`? Just the distinct list, one column. Don't worry about counting or normalizing — I want to see them raw so I can spot any drift.
| Column | Type | Key |
|---|---|---|
| sku_id | INT | PK |
| sku_code | TEXT | |
| sku_name | TEXT | |
| category | TEXT | |
| unit_cost | REAL | |
| reorder_point | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Use `SELECT DISTINCT category FROM dim_skus`.
ORDER BY category for readability.
You'll see 6 rows — there's a planted casing-drift bug ('Electronics' vs 'electronics'). Raj wants to see them as-is so he knows the dim is dirty.