Table schema:
CREATE TABLE people (Party VARCHAR)

Question: Show different parties of people along with the number of people in each party.
SQL: SELECT Party, COUNT(*) FROM people GROUP BY Party