How many hosts does each nationality have? List the nationality and the count with a bar chart.
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
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 with a bar chart. ### 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