Warranty Claims Pareto and Months-in-Service SQL Query Generator

SELECT
  failure_mode_code AS failure_mode,
  COUNT(*) AS claim_count,
  SUM(claim_cost) AS total_cost,
  100.0 * COUNT(*) / SUM(COUNT(*)) OVER () AS pct_of_claims,
  100.0 * SUM(COUNT(*)) OVER (ORDER BY COUNT(*) DESC, failure_mode_code) / SUM(COUNT(*)) OVER () AS cumulative_pct
FROM warranty_claims
WHERE part_no = 'AS-BRKT-210'
  AND claim_date >= '2025-01-01'
  AND claim_date <= '2026-09-30'
GROUP BY failure_mode_code
ORDER BY claim_count DESC;

SELECT
  DATEDIFF(month, in_service_date, claim_date) AS months_in_service,
  COUNT(*) AS claim_count,
  SUM(claim_cost) AS total_cost
FROM warranty_claims
WHERE part_no = 'AS-BRKT-210'
  AND claim_date >= '2025-01-01'
  AND claim_date <= '2026-09-30'
GROUP BY DATEDIFF(month, in_service_date, claim_date)
ORDER BY months_in_service;

SELECT
  (EXTRACT(YEAR FROM age(claim_date, in_service_date)) * 12
   + EXTRACT(MONTH FROM age(claim_date, in_service_date)))::int AS months_in_service,
  COUNT(*) AS claim_count,
  SUM(claim_cost) AS total_cost
FROM warranty_claims
WHERE part_no = 'AS-BRKT-210'
  AND claim_date >= '2025-01-01'
  AND claim_date <= '2026-09-30'
GROUP BY 1
ORDER BY 1;