SELECT * FROM ( SELECT DISTINCT ON (t.fire_department_id_number, t.state) headers.fd_name, t.* FROM ( SELECT fires.state, fires.fire_department_id_number, AVG(fires.arrival_at - fires.alarm_at) / 60 AS time, COUNT(*) AS incidents FROM nfirs_basic_fire_incidents AS fires WHERE (fires.arrival_at - fires.alarm_at) <= '60 minutes' AND fires.property_use = '419' OR fires.property_use = '429' AND fires.published_year::INT BETWEEN 2018 AND 2022 GROUP BY fires.state, fires.fire_department_id_number ORDER BY COUNT(*) DESC LIMIT 500 ) AS t JOIN raw_fd_headers AS headers ON (t.fire_department_id_number = headers.fdid AND t.state = headers.state) ) AS s ORDER BY s.incidents DESC;