SELECT policy_type_code ,  count(*) FROM policies GROUP BY policy_type_code
Find the number of records of each policy type and its type code.
SELECT policy_type_code , count ( * ) FROM policies GROUP BY policy_type_code
select policy_type_code , count ( * ) from policies group by policy_type_code
Find the number of records of each policy type and its type code .