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)
CREATE TABLE party_host (Party_ID NUMBER, Host_ID NUMBER, Is_Main_in_Charge BOOLEAN)

Show me a pie chart for 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"