Could you tell me: how many aircraft at campbell army airfield are in the depot await status and assigned to the location associated with 101st airborne??
SELECT COUNT(*) AS count FROM aircraft WHERE location__name = 'Campbell Army Airfield' AND status = 'DADE' AND location__name = 'Campbell Army Airfield';