CREATE TABLE party_host (party_id NUMBER, host_id NUMBER, is_main_in_charge others)
CREATE TABLE party (party_id NUMBER, party_theme CLOB, location CLOB, first_year CLOB, last_year CLOB, number_of_hosts NUMBER)
CREATE TABLE host (host_id NUMBER, name CLOB, nationality CLOB, age CLOB)

How many hosts does each nationality have? List the nationality and the count.
SELECT nationality, COUNT(*) FROM host GROUP BY nationality
SELECT "nationality", COUNT(*) FROM "host" GROUP BY "nationality"