Complex~37min
The Compliant Fraud
Every individual claim Dr. Rodriguez submits is valid and within policy limits. Auto-approval threshold is ₹5,000. His claims are always ₹4,999. Insurance flagged it. Prove it.
Tables you'll query
providersinsurance_claimspatientspolicy_limits
What you'll learn
Window FunctionsAggregations & GROUP BYCTEs (WITH clause)Subqueries