How many members are there?
select count(*) from member
How many are in the Progressive party?
select count(*) from member as t1 join party as t2 on t1.party_id = t2.party_id where t2.party_name = "Progress Party"
How many are not?
select count(*) from member as t1 join party as t2 on t1.party_id = t2.party_id where t2.party_name != "Progress Party"
What are their names?
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"