Your inventory team needs a clear availability status for every product. Using the products table, label each product 'In Stock' if stock_qty is greater than 0, or 'Out of Stock' if it is 0. Return name, category, stock_qty, and availability, sorted by name ascending.
products
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| category | TEXT |
| stock_qty | INT |
| id | name | category | stock_qty |
|---|---|---|---|
| 1 | Keyboard | Electronics | 15 |
| 2 | Mouse | Electronics | 0 |
| 3 | Notebook | Stationery | 42 |
| 4 | Pen | Stationery | 0 |
| 5 | Webcam | Electronics | 3 |
| name | category | stock_qty | availability |
|---|---|---|---|
| Keyboard | Electronics | 15 | In Stock |
| Mouse | Electronics | 0 | Out of Stock |
| Notebook | Stationery | 42 | In Stock |
| Pen | Stationery | 0 | Out of Stock |
| Webcam | Electronics | 3 | In Stock |
Keyboard, Notebook, and Webcam all have stock_qty > 0, so they are 'In Stock'. Mouse and Pen have stock_qty = 0, so they are 'Out of Stock'.