Show all template type codes and number of templates for each.
CREATE TABLE Templates (template_type_code VARCHAR)
SELECT template_type_code, COUNT(*) FROM Templates GROUP BY template_type_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Templates (template_type_code VARCHAR) Question: Show all template type codes and number of templates for each. [/INST] SELECT template_type_code, COUNT(*) FROM Templates GROUP BY template_type_code </s>