Please show different software platforms and the corresponding number of devices using each.
CREATE TABLE device (Software_Platform VARCHAR)
SELECT Software_Platform, COUNT(*) FROM device GROUP BY Software_Platform
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE device (Software_Platform VARCHAR) Question: Please show different software platforms and the corresponding number of devices using each. [/INST] SELECT Software_Platform, COUNT(*) FROM device GROUP BY Software_Platform </s>