Count the number of local authorities by the local authority, sort X in ascending order.
CREATE TABLE route (
    train_id int,
    station_id int
)

CREATE TABLE station (
    id int,
    network_name text,
    services text,
    local_authority text
)

CREATE TABLE train (
    id int,
    train_number int,
    name text,
    origin text,
    destination text,
    time text,
    interval text
)

CREATE TABLE weekly_weather (
    station_id int,
    day_of_week text,
    high_temperature int,
    low_temperature int,
    precipitation real,
    wind_speed_mph int
)
SELECT local_authority, COUNT(local_authority) FROM station GROUP BY local_authority ORDER BY local_authority
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: Count the number of local authorities by the local authority, sort X in ascending order. ### Input: CREATE TABLE route (
    train_id int,
    station_id int
)

CREATE TABLE station (
    id int,
    network_name text,
    services text,
    local_authority text
)

CREATE TABLE train (
    id int,
    train_number int,
    name text,
    origin text,
    destination text,
    time text,
    interval text
)

CREATE TABLE weekly_weather (
    station_id int,
    day_of_week text,
    high_temperature int,
    low_temperature int,
    precipitation real,
    wind_speed_mph int
) ### Response: SELECT local_authority, COUNT(local_authority) FROM station GROUP BY local_authority ORDER BY local_authority