Finance wants to understand billing patterns. Calculate the average billing amount for each billing status. Return status and avg_amount (rounded to 2 decimal places), ordered by avg_amount 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