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

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