Database: insurance_and_eClaims
Question: Find the number of records of each policy type and its type code.
SQL:
SELECT policy_type_code ,  count(*) FROM policies GROUP BY policy_type_code