SELECT Location, COUNT(Location) FROM shop GROUP BY Location ORDER BY COUNT(Location)
Return a bar chart showing how many shops in each location, could you rank how many location in ascending order please?
CREATE TABLE device (
    Device_ID int,
    Device text,
    Carrier text,
    Package_Version text,
    Applications text,
    Software_Platform text
)

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
)