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

I want to know the proportion of the total number for each carrier.
SELECT Carrier, COUNT(*) FROM phone GROUP BY Carrier
SELECT "Carrier", COUNT(*) FROM "phone" GROUP BY "Carrier"