Database: cre_Doc_Template_Mgt
Question: Show all template type codes and number of templates for each.
SQL:
SELECT template_type_code ,  count(*) FROM Templates GROUP BY template_type_code