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