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