SELECT Carrier FROM phone GROUP BY Carrier ORDER BY COUNT(*) DESC LIMIT 1
Show the most frequently used carrier of the phones.
SELECT Carrier FROM phone GROUP BY Carrier ORDER BY COUNT ( * ) DESC LIMIT 1
select carrier from phone group by carrier order by count ( * ) desc limit value
Show the most frequently used carrier of the phones .