Quick question: how did you learn to code? It probably wasn’t bribing someone a year or two ahead of you in CS to finish all ...
ROUND((AVG(EXTRACT(EPOCH FROM (i.resolutiondatetime - i.incidentdatetime)) / 3600.0))::numeric, 4) AS avg_hours, ROUND((AVG(EXTRACT(EPOCH FROM (i.resolutiondatetime ...