Show different carriers of phones together with the number of phones with each carrier.
CREATE TABLE phone (Carrier VARCHAR)
SELECT Carrier, COUNT(*) FROM phone GROUP BY Carrier
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE phone (Carrier VARCHAR) Question: Show different carriers of phones together with the number of phones with each carrier. [/INST] SELECT Carrier, COUNT(*) FROM phone GROUP BY Carrier </s>