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