Skip to main content
All Problems
easy0% acceptance

Total Billing Amount by Status

The billing department wants to see the total billed amount grouped by billing status. Return each status and the sum of amount, rounded to two decimal places, ordered by total descending.

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