CREATE TABLE policies (policy_type_code VARCHAR)

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"