Verify Policy-to-Claims Cascade

How do you query a database to verify that a policy update correctly cascaded to related claims records?

Write a PostgreSQL query that evaluates the latest applied update for each policy against claims that existed when the update was applied. Treat a claim as compliant only when its policy version and limit match the update.

Output

1. One row per policy with an applied update.
2. Return policy_id, policy_name, update_id, expected_version, expected_limit, related_claim_count, compliant_claim_count, noncompliant_claim_count, and cascade_status.
3. Include policies with no qualifying claims, classify them as verified, and order by policy_id.