CREATE TABLE shop (Shop_ID NUMBER, Shop_Name CLOB, Location CLOB, Open_Date CLOB, Open_Year NUMBER)
CREATE TABLE device (Device_ID NUMBER, Device CLOB, Carrier CLOB, Package_Version CLOB, Applications CLOB, Software_Platform CLOB)
CREATE TABLE stock (Shop_ID NUMBER, Device_ID NUMBER, Quantity NUMBER)

Create a bar chart showing how many location across location, list Y from high to low order.
SELECT Location, COUNT(Location) FROM shop GROUP BY Location ORDER BY COUNT(Location) DESC
SELECT "Location", COUNT("Location") FROM "shop" GROUP BY "Location" ORDER BY COUNT("Location") DESC