The accounts receivable team needs the total dollar amount of all pending bills. Return a single value: the SUM of amount for billing records where status is 'pending'.
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