NCR Trend SQL Query Generator (Pareto by Supplier, Part, Cause)

-- NCR Pareto by supplier_id, 2026-01-01 to 2026-09-30
-- Table and column names are generic. Replace with your schema.
SELECT
  supplier_id AS category,
  COUNT(*) AS ncr_count,
  SUM(qty_rejected) AS total_qty_rejected,
  ROUND(100.0 * COUNT(*) / SUM(COUNT(*)) OVER (), 1) AS pct_of_total,
  ROUND(100.0 * SUM(COUNT(*)) OVER (ORDER BY COUNT(*) DESC ROWS UNBOUNDED PRECEDING) / SUM(COUNT(*)) OVER (), 1) AS cumulative_pct
FROM quality_ncr
WHERE ncr_date >= '2026-01-01'
  AND ncr_date <= '2026-09-30'
GROUP BY supplier_id
ORDER BY ncr_count DESC
LIMIT 10;

-- Monthly NCR count trend
SELECT
  EXTRACT(YEAR FROM ncr_date) AS yr,
  EXTRACT(MONTH FROM ncr_date) AS mon,
  COUNT(*) AS ncr_count
FROM quality_ncr
WHERE ncr_date >= '2026-01-01'
  AND ncr_date <= '2026-09-30'
GROUP BY EXTRACT(YEAR FROM ncr_date), EXTRACT(MONTH FROM ncr_date)
ORDER BY yr, mon;