CREATE TABLE phone (Carrier VARCHAR2)

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