How many hosts does each nationality have? List the nationality and the count Visualize by bar chart, could you list in ascending by the y axis?
CREATE TABLE party_host (
    Party_ID int,
    Host_ID int,
    Is_Main_in_Charge bool
)

CREATE TABLE host (
    Host_ID int,
    Name text,
    Nationality text,
    Age text
)

CREATE TABLE party (
    Party_ID int,
    Party_Theme text,
    Location text,
    First_year text,
    Last_year text,
    Number_of_hosts int
)
SELECT Nationality, COUNT(*) FROM host GROUP BY Nationality ORDER BY COUNT(*)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many hosts does each nationality have? List the nationality and the count Visualize by bar chart, could you list in ascending by the y axis? ### Input: CREATE TABLE party_host (
    Party_ID int,
    Host_ID int,
    Is_Main_in_Charge bool
)

CREATE TABLE host (
    Host_ID int,
    Name text,
    Nationality text,
    Age text
)

CREATE TABLE party (
    Party_ID int,
    Party_Theme text,
    Location text,
    First_year text,
    Last_year text,
    Number_of_hosts int
) ### Response: SELECT Nationality, COUNT(*) FROM host GROUP BY Nationality ORDER BY COUNT(*)