Which categories are overstocked and which are understocked? Walmart's inventory team needs a query to answer that. Using the products table, return category and product_count, ordered from most to fewest products.
products
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| category | TEXT |
| price | NUMERIC |
| id | name | category | price |
|---|---|---|---|
| 1 | Widget | Tools | 9.99 |
| 2 | Gadget | Electronics | 149.99 |
| 3 | Gizmo | Electronics | 79.99 |
| 4 | Doohickey | Tools | 24.99 |
| 5 | Bracelet | Accessories | 19.99 |
| 6 | Wrench | Tools | 14.99 |
| category | product_count |
|---|---|
| Tools | 3 |
| Electronics | 2 |
| Accessories | 1 |
Tools has 3 products, Electronics has 2, and Accessories has 1. Results are sorted by product count descending.