CREATE TABLE church (church_id DECIMAL, name TEXT, organized_by TEXT, open_date DECIMAL, continuation_of TEXT)
CREATE TABLE people (people_id DECIMAL, name TEXT, country TEXT, is_male TEXT, age DECIMAL)
CREATE TABLE wedding (church_id DECIMAL, male_id DECIMAL, female_id DECIMAL, year DECIMAL)

Show all countries and the number of people from each country.
SELECT country, COUNT(*) FROM people GROUP BY country
SELECT "country", COUNT(*) FROM "people" GROUP BY "country"