COUNT — peek at the SKU dim and produce a single scalar.
While we're at it — how many SKUs are in `dim_skus`? Just a count. (Heads up: there's at least one duplicated `sku_code` in there from a bad load. Just count rows, don't worry about dedup'ing for now — we'll handle that in a follow-up mission.)
| 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.
One table: `dim_skus`. Count its rows with `COUNT(*)`.
The full query is `SELECT COUNT(*) FROM dim_skus`.
30 rows total. The duplicated sku_code rows DO count separately because they have different `sku_id`s — that's exactly the data quality issue.