Show different type codes of products and the number of products with each type code.
create table products (product_type_code varchar, PRIMARY KEY (product_type_code))
select product_type_code, count(*) from products group by product_type_code