Table schema:
CREATE TABLE phone (Carrier VARCHAR)

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