Expired Inventory Alert

SQL Query:


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

Executing query… 0s

Expired Inventory Items