CREATE TABLE market (Market_ID NUMBER, District CLOB, Num_of_employees NUMBER, Num_of_shops FLOAT, Ranking NUMBER)
CREATE TABLE phone_market (Market_ID NUMBER, Phone_ID CLOB, Num_of_stock NUMBER)
CREATE TABLE phone (Name CLOB, Phone_ID NUMBER, Memory_in_G NUMBER, Carrier CLOB, Price FLOAT)

What is the number of carriers of phones? Give me a bar chart, could you order in desc by the Carrier?
SELECT Carrier, COUNT(Carrier) FROM phone GROUP BY Carrier ORDER BY Carrier DESC
SELECT "Carrier", COUNT("Carrier") FROM "phone" GROUP BY "Carrier" ORDER BY "Carrier" DESC