Show different type codes of products and the number of products with each type code.
CREATE TABLE Products (Product_Type_Code VARCHAR)
SELECT Product_Type_Code, COUNT(*) FROM Products GROUP BY Product_Type_Code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Products (Product_Type_Code VARCHAR) Question: Show different type codes of products and the number of products with each type code. [/INST] SELECT Product_Type_Code, COUNT(*) FROM Products GROUP BY Product_Type_Code </s>