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)

Show how many carrriers for each shops in a bar chart, and list in descending by the y-axis please.
SELECT Shop_Name, COUNT(Shop_Name) FROM stock AS T1 JOIN device AS T2 ON T1.Device_ID = T2.Device_ID JOIN shop AS T3 ON T1.Shop_ID = T3.Shop_ID GROUP BY Shop_Name ORDER BY COUNT(Shop_Name) DESC
SELECT "Shop_Name", COUNT("Shop_Name") FROM "stock" "T1" JOIN "device" "T2" ON "T1"."Device_ID" = "T2"."Device_ID" JOIN "shop" "T3" ON "T1"."Shop_ID" = "T3"."Shop_ID" GROUP BY "Shop_Name" ORDER BY COUNT("Shop_Name") DESC