SELECT
fp.pantry_name,
i.name AS item_name,
i.quantity AS qty,
i.expiration_date
FROM Inventory i
JOIN Food_Pantries fp ON i.pantry_id = fp.pantry_id
WHERE i.expiration_date < CURDATE()
ORDER BY i.expiration_date ASC
| Pantry | Item | Quantity | Expired On |
|---|---|---|---|
| West End Pantry | Peanut Butter | 80 | 2025-10-30 |
| Eastside Pantry | Cereal | 120 | 2025-11-30 |
| Downtown Pantry TEST | Canned Beans | 100 | 2025-12-31 |
| Eastside Pantry | Pasta | 150 | 2026-01-15 |