Your Factory’s Data, Finally Making Sense.

SELECT 
  stenter_id,
  ROUND(AVG(delta_e_00)::numeric, 3) AS avg_delta_e,
  COUNT(batch_id) AS total_batches,
  ROUND(SUM(CASE WHEN rework_flag THEN 1 ELSE 0 END)::numeric / COUNT(batch_id) * 100, 1) AS rework_pct
FROM production_batches
WHERE shade_category = 'Reactive Navy'
  AND timestamp >= NOW() - INTERVAL '7 days'
GROUP BY stenter_id
ORDER BY avg_delta_e ASC;