SELECT template_type_code FROM Templates GROUP BY template_type_code HAVING count(*)  <  3
Show all template type codes with less than three templates.
SELECT template_type_code FROM Templates GROUP BY template_type_code HAVING count ( * ) < 3
select template_type_code from templates group by template_type_code having count ( * ) < value
Show all template type codes with less than three templates .