Bar chart x axis headquarters y axis the total number, and sort by the bars in asc.
CREATE TABLE company (
    Company_ID real,
    Name text,
    Headquarters text,
    Industry text,
    Sales_in_Billion real,
    Profits_in_Billion real,
    Assets_in_Billion real,
    Market_Value_in_Billion real
)

CREATE TABLE employment (
    Company_ID int,
    People_ID int,
    Year_working int
)

CREATE TABLE people (
    People_ID int,
    Age int,
    Name text,
    Nationality text,
    Graduation_College text
)
SELECT Headquarters, COUNT(*) FROM company GROUP BY Headquarters ORDER BY Headquarters
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: Bar chart x axis headquarters y axis the total number, and sort by the bars in asc. ### Input: CREATE TABLE company (
    Company_ID real,
    Name text,
    Headquarters text,
    Industry text,
    Sales_in_Billion real,
    Profits_in_Billion real,
    Assets_in_Billion real,
    Market_Value_in_Billion real
)

CREATE TABLE employment (
    Company_ID int,
    People_ID int,
    Year_working int
)

CREATE TABLE people (
    People_ID int,
    Age int,
    Name text,
    Nationality text,
    Graduation_College text
) ### Response: SELECT Headquarters, COUNT(*) FROM company GROUP BY Headquarters ORDER BY Headquarters