CREATE TABLE stock (Shop_ID NUMBER, Device_ID NUMBER, Quantity NUMBER)
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)

Give a bar chart showing how many shops in each carrier, I want to show by the bars from high to low.
SELECT Carrier, COUNT(Carrier) 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 Carrier ORDER BY Carrier DESC
SELECT "Carrier", COUNT("Carrier") 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 "Carrier" ORDER BY "Carrier" DESC