SELECT T1.template_type_code ,  count(*) FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id  =  T2.template_id GROUP BY T1.template_type_code
Show all template type codes and the number of documents using each type.
SELECT T1.template_type_code , count ( * ) FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_type_code
select t1 . template_type_code , count ( * ) from templates as t1 join documents as t2 on t1 . template_id = t2 . template_id group by t1 . template_type_code
Show all template type codes and the number of documents using each type .