Overdue PM Work Orders SQL Query Generator

SELECT wo.wo_number,
       wo.asset_id,
       wo.due_date,
       DATEDIFF(day, wo.due_date, CAST(GETDATE() AS date)) AS days_overdue
FROM work_orders wo
WHERE wo.work_type = 'PM'
  AND wo.completed_date IS NULL
  AND wo.due_date < DATEADD(day, -0, CAST(GETDATE() AS date))
ORDER BY days_overdue DESC;

SELECT wo.wo_number,
       wo.asset_id,
       wo.due_date,
       (CURRENT_DATE - wo.due_date::date) AS days_overdue
FROM work_orders wo
WHERE wo.work_type = 'PM'
  AND wo.completed_date IS NULL
  AND wo.due_date::date < CURRENT_DATE - 0
ORDER BY days_overdue DESC;

SELECT date_trunc('month', wo.due_date) AS due_month,
       COUNT(*) AS pms_due,
       COUNT(*) FILTER (WHERE wo.completed_date IS NOT NULL AND wo.completed_date::date <= wo.due_date::date + 0) AS pms_on_time,
       ROUND(100.0 * COUNT(*) FILTER (WHERE wo.completed_date IS NOT NULL AND wo.completed_date::date <= wo.due_date::date + 0) / NULLIF(COUNT(*), 0), 1) AS compliance_pct
FROM work_orders wo
WHERE wo.work_type = 'PM'
  AND wo.due_date < CURRENT_DATE
GROUP BY 1
ORDER BY 1;