GROUP BY with COUNT
Welcome aboard. Quick orient — how many SKUs are in each lifecycle (NPI, ACTIVE, EOL)? Show lifecycle and sku_count.
| Column | Type | Key |
|---|---|---|
| sku_id | INT | PK |
| sku_code | TEXT | |
| sku_name | TEXT | |
| category | TEXT | |
| lifecycle | TEXT | |
| abc_class | TEXT | |
| xyz_class | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
There's a categorical column on each SKU that buckets it into a phase — partition by that, then count.
COUNT(*).
Two columns.