Looking for which location has the highest combined total airframe hours for hh-60m models with ready after maintenance status??
SELECT location__name, SUM(total_airframe_hours) AS total_hours FROM aircraft WHERE model = 'HH-60M' AND status = 'PMCM' GROUP BY location__name ORDER BY total_hours DESC LIMIT 1;