CREATE TABLE round (round_id NUMBER, member_id NUMBER, decoration_theme CLOB, rank_in_round NUMBER)
CREATE TABLE college (college_id NUMBER, name CLOB, leader_name CLOB, college_location CLOB)
CREATE TABLE member (member_id NUMBER, name CLOB, country CLOB, college_id NUMBER)

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