SCHEMA:
CREATE TABLE people (Party VARCHAR)
User Question:
Show different parties of people along with the number of people in each party.


SELECT Party, COUNT(*) FROM people GROUP BY Party