Skip to main content
All Problems
medium0% acceptance

Monthly Revenue with Month-over-Month Change

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