what are all of the retired rockets that were manufactured by army ballistic missile agency?
(AND spaceflight.rocket (AND (JOIN spaceflight.rocket.status m.021y97l) (JOIN (R spaceflight.rocket_manufacturer.rockets_manufactured) m.012z7w)))