COUNT(*) on a dimension table
Welcome aboard. First gut-check — how many suppliers are in our master `dim_suppliers` table? Single number, alias it `supplier_count`.
| Column | Type | Key |
|---|---|---|
| supplier_id | INT | PK |
| supplier_name | TEXT | |
| country | TEXT | |
| tier | INT | |
| category_focus | TEXT | |
| diversity_certified | INT | |
| payment_terms_days | INT | |
| is_preferred | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
There's a single-table aggregate that returns one number — count every row.
No filter — count every row.
Alias the column as supplier_count.