SELECT all rows from a dimension, sorted
Pull every category from `dim_categories` sorted alphabetically by `category_name`. I want to see manager and spend type for each.
| Column | Type | Key |
|---|---|---|
| category_id | INT | PK |
| category_name | TEXT | |
| category_manager | TEXT | |
| spend_type | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Single-table query against dim_categories.
ORDER BY category_name ascending.
No filter — all 8 categories.