SELECT Carrier ,  COUNT(*) FROM phone GROUP BY Carrier
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
Show different carriers of phones together with the number of phones with each carrier .