What are all the party names?
select party_name from party
Show me all the members each have.
select * from member as t1 join party as t2 on t1.party_id = t2.party_id
How many does each party have?
select t2.party_name, count(*) from member as t1 join party as t2 on t1.party_id = t2.party_id group by party_name