Create a bar chart showing how many location across location, and show names from low to high order.
CREATE TABLE shop (
    Shop_ID int,
    Shop_Name text,
    Location text,
    Open_Date text,
    Open_Year int
)

CREATE TABLE stock (
    Shop_ID int,
    Device_ID int,
    Quantity int
)

CREATE TABLE device (
    Device_ID int,
    Device text,
    Carrier text,
    Package_Version text,
    Applications text,
    Software_Platform text
)
SELECT Location, COUNT(Location) FROM shop 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: Create a bar chart showing how many location across location, and show names from low to high order. ### Input: CREATE TABLE shop (
    Shop_ID int,
    Shop_Name text,
    Location text,
    Open_Date text,
    Open_Year int
)

CREATE TABLE stock (
    Shop_ID int,
    Device_ID int,
    Quantity int
)

CREATE TABLE device (
    Device_ID int,
    Device text,
    Carrier text,
    Package_Version text,
    Applications text,
    Software_Platform text
) ### Response: SELECT Location, COUNT(Location) FROM shop GROUP BY Location ORDER BY Location