Need info on find the top three units with the highest total hours to phase for AH-64D currently listed as not ready due to supply.?
SELECT current_unit, SUM(hours_to_phase) AS total_hours FROM aircraft WHERE model = 'AH-64D' AND status = 'NMCS' GROUP BY current_unit ORDER BY total_hours DESC LIMIT 3;