Return a bar chart showing how many shops in each location, and I want to display in descending by the y-axis.
CREATE TABLE shop (
    Shop_ID int,
    Shop_Name text,
    Location text,
    Open_Date text,
    Open_Year int
)

CREATE TABLE device (
    Device_ID int,
    Device text,
    Carrier text,
    Package_Version text,
    Applications text,
    Software_Platform text
)

CREATE TABLE stock (
    Shop_ID int,
    Device_ID int,
    Quantity int
)
SELECT Location, COUNT(Location) FROM shop GROUP BY Location ORDER BY COUNT(Location) DESC
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: Return a bar chart showing how many shops in each location, and I want to display in descending by the y-axis. ### Input: CREATE TABLE shop (
    Shop_ID int,
    Shop_Name text,
    Location text,
    Open_Date text,
    Open_Year int
)

CREATE TABLE device (
    Device_ID int,
    Device text,
    Carrier text,
    Package_Version text,
    Applications text,
    Software_Platform text
)

CREATE TABLE stock (
    Shop_ID int,
    Device_ID int,
    Quantity int
) ### Response: SELECT Location, COUNT(Location) FROM shop GROUP BY Location ORDER BY COUNT(Location) DESC