MRO Open Work Order Aging SQL Query Generator

SELECT
  station,
  COUNT(*) AS open_work_orders,
  SUM(CASE WHEN DATEDIFF(day, open_date, GETDATE()) <= 7 THEN 1 ELSE 0 END) AS age_0_to_7,
  SUM(CASE WHEN DATEDIFF(day, open_date, GETDATE()) > 7 AND DATEDIFF(day, open_date, GETDATE()) <= 30 THEN 1 ELSE 0 END) AS age_7_to_30,
  SUM(CASE WHEN DATEDIFF(day, open_date, GETDATE()) > 30 AND DATEDIFF(day, open_date, GETDATE()) <= 90 THEN 1 ELSE 0 END) AS age_30_to_90,
  SUM(CASE WHEN DATEDIFF(day, open_date, GETDATE()) > 90 THEN 1 ELSE 0 END) AS age_over_90
FROM work_orders
WHERE status NOT IN ('CLOSED','CANCELLED')
GROUP BY station
ORDER BY open_work_orders DESC;

SELECT TOP 50
  wo_number,
  station,
  status,
  open_date,
  DATEDIFF(day, open_date, GETDATE()) AS age_days
FROM work_orders
WHERE status NOT IN ('CLOSED','CANCELLED')
ORDER BY age_days DESC;

-- PostgreSQL
SELECT wo_number, station, status, open_date,
       (CURRENT_DATE - open_date::date) AS age_days
FROM work_orders
WHERE status NOT IN ('CLOSED','CANCELLED')
ORDER BY age_days DESC
LIMIT 50;

-- Oracle
SELECT wo_number, station, status, open_date,
       TRUNC(SYSDATE - open_date) AS age_days
FROM work_orders
WHERE status NOT IN ('CLOSED','CANCELLED')
ORDER BY age_days DESC
FETCH FIRST 50 ROWS ONLY;