Build a monthly revenue trend report. For each month (YYYY-MM), show the total billing amount, and the change from the previous month. Return month, total_revenue, and revenue_change. Sort by month ascending.
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