Database: insurance_and_eClaims
Question: For each policy type, return its type code and its count in the record.
SQL:
SELECT policy_type_code ,  count(*) FROM policies GROUP BY policy_type_code