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