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