Inventory Turnover Rate

SQL Query:


SELECT
  i.name             AS item_name,
  SUM(fd.quantity)   AS total_out,
  AVG(i.quantity)    AS avg_in_stock,
  SUM(fd.quantity)/GREATEST(AVG(i.quantity),1) AS turnover_rate
FROM Food_Distributions fd
JOIN Inventory i ON fd.supply_id = i.supply_id
WHERE fd.date >= DATE_SUB(CURDATE(),INTERVAL 1 YEAR)
GROUP BY i.supply_id
ORDER BY turnover_rate DESC
LIMIT 20

Executing query… 0s

Item	Total Distributed	Avg In Stock	Turnover Rate
Canned Beans	10	100	0.10
Rice	8	200	0.04
Pasta	5	150	0.03
Peanut Butter	2	80	0.03

Top 20 Items by Inventory Turnover Rate