iof UH-60 Mike Medevac at Fort Campbell, how many hanbzphase hours oper 500 and pre still marked as zIELD?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'HH-60M' AND location__name = 'Campbell AAF' AND hours_to_phase > 500 AND status = 'FIELD';