A bar chart shows how many locations, and order in ascending by the X-axis please.
CREATE TABLE station (
    Station_ID int,
    Name text,
    Annual_entry_exit real,
    Annual_interchanges real,
    Total_Passengers real,
    Location text,
    Main_Services text,
    Number_of_Platforms int
)

CREATE TABLE train (
    Train_ID int,
    Name text,
    Time text,
    Service text
)

CREATE TABLE train_station (
    Train_ID int,
    Station_ID int
)
SELECT Location, COUNT(Location) FROM station GROUP BY Location ORDER BY Location
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: A bar chart shows how many locations, and order in ascending by the X-axis please. ### Input: CREATE TABLE station (
    Station_ID int,
    Name text,
    Annual_entry_exit real,
    Annual_interchanges real,
    Total_Passengers real,
    Location text,
    Main_Services text,
    Number_of_Platforms int
)

CREATE TABLE train (
    Train_ID int,
    Name text,
    Time text,
    Service text
)

CREATE TABLE train_station (
    Train_ID int,
    Station_ID int
) ### Response: SELECT Location, COUNT(Location) FROM station GROUP BY Location ORDER BY Location