Database: cre_Doc_Template_Mgt
Question: Return the id and type code of the template that is used for the greatest number of documents.
SQL:
SELECT T1.template_id ,  T2.Template_Type_Code FROM Documents AS T1 JOIN Templates AS T2 ON T1.template_id  =  T2.template_id GROUP BY T1.template_id ORDER BY count(*) DESC LIMIT 1