ROUND((AVG(EXTRACT(EPOCH FROM (i.resolutiondatetime - i.incidentdatetime)) / 3600.0))::numeric, 4) AS avg_hours, ROUND((AVG(EXTRACT(EPOCH FROM (i.resolutiondatetime ...