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 |
|---|