compass airlines is in which alliance?
(AND aviation.airline_alliance (JOIN aviation.airline_alliance.member_airlines m.0c26nt))