The first table is PolicyTable, with fields: PolicyNbr, IssueDate, ExpireDate, Product, Channel, Premium. The policyNbr is a unique number.
The second table is ClaimTable, with fields: ClaimNbr, PolicyNbr, ReportDate, PaymentDate, PaymentAmount. This is a transaction record table, there is no primary key field. A claim could have multiple policies and multiple payments. A policy could also have multiple claims.
The questions I want to solve are,
On a evaluate date,
1) How many policies have claims?
2) How many claims does each policy have?
The difficulty I have here is the many to many relationship between PolicyNbr and ClaimNbr. I don't know what's the most efficient way to do the analysis.
