Problem
Out-of-stock products create a poor shopping experience and represent lost revenue. Warehouse and procurement teams run daily queries to identify items that have completely sold out so they can raise purchase orders before customers notice the gap. Using the products table, find every product with a stock of 0 — return id and name, ordered by id.
Schema
products
| column | type |
|---|
| id | INTEGER |
| name | TEXT |
| category | TEXT |
| price | NUMERIC |
| stock | INTEGER |
Sample Data
| id | name | category | price | stock |
|---|
| 1 | Widget | Tools | 9.99 | 5 |
| 2 | Gadget | Electronics | 149.99 | 0 |
| 3 | Gizmo | Electronics | 79.99 | 12 |
| 4 | Doohickey | Tools | 24.99 | 0 |
| 5 | Bracelet | Accessories | 19.99 | 3 |
Expected Output