Which member names corresponding to members who are not in the Progress Party?
SELECT T1.member_name FROM Member AS T1 JOIN party AS T2 ON T1.party_id  =  T2.party_id WHERE T2.Party_name != "Progress Party"
members not in the Progress Party refers to WHERE Party_name != 'Progress Party'; member names corresponding to these members refers to SELECT member_name; joining tables Member and party to check party affiliation refers to JOIN ON Member.party_id = party.party_id;