CREATE TABLE party_host (Party_ID NUMBER, Host_ID NUMBER, Is_Main_in_Charge BOOLEAN)
CREATE TABLE host (Host_ID NUMBER, Name CLOB, Nationality CLOB, Age CLOB)
CREATE TABLE party (Party_ID NUMBER, Party_Theme CLOB, Location CLOB, First_year CLOB, Last_year CLOB, Number_of_hosts NUMBER)

A bar chart about how many hosts does each nationality have? List the nationality and the count, and display by the Y in ascending.
SELECT Nationality, COUNT(*) FROM host GROUP BY Nationality ORDER BY COUNT(*)
SELECT "Nationality", COUNT(*) FROM "host" GROUP BY "Nationality" ORDER BY COUNT(*)