How many settlements does each claim correspond to? List the claim id and the number of settlements.
create table settlements (claim_id varchar, PRIMARY KEY (claim_id)); create table claims (claim_id varchar, claim_id varchar, PRIMARY KEY (claim_id))
select t1.claim_id, count(*) from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id group by t1.claim_id