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

Show different carriers of phones together with the number of phones with each carrier. Plot them as bar chart.
SELECT Carrier, COUNT(*) FROM phone GROUP BY Carrier
SELECT "Carrier", COUNT(*) FROM "phone" GROUP BY "Carrier"