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

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"