How many members are in each party?
select t2.party_name, count(*) from member as t1 join party as t2 on t1.party_id = t2.party_id group by t1.party_id