How many parties are there?
select count(distinct party) from people
How many people are there in each party?
select party, count(*) from people group by party
Which party has the most people?
select party from people group by party order by count(*) desc limit 1