Skip to main content
All Problems
easy0% acceptance

Min and Max Billing Amounts

Finance wants to understand the billing range. For each billing status, return the minimum amount, maximum amount, and average amount (rounded to 2 decimal places).

Schema

🔑idINT
🔗visit_idINT
amountREAL
insurance_coveredREAL
patient_responsibilityREAL
statusTEXT
billed_atTEXT
paid_atTEXTNULL
postgresql

Run your query to see results

Press Ctrl + Enter to execute