CREATE TABLE party_host (Party_ID NUMBER, Host_ID NUMBER, Is_Main_in_Charge BOOLEAN)
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 Visualize by bar chart, order in descending by the Y-axis please.
SELECT Nationality, COUNT(*) FROM host GROUP BY Nationality ORDER BY COUNT(*) DESC
SELECT "Nationality", COUNT(*) FROM "host" GROUP BY "Nationality" ORDER BY COUNT(*) DESC