Looking for find the top three units with the highest total hours to phase for CH-47F currently listed as fully operational.?
SELECT current_unit, SUM(hours_to_phase) AS total_hours FROM aircraft WHERE model = 'CH-47FM3' AND status = 'FMC' GROUP BY current_unit ORDER BY total_hours DESC LIMIT 3;