Write a query to calculate running totals of loan disbursements by day.
Use the provided loan disbursement records. Include every date represented in the data, treating a date with only NULL disbursement amounts as zero.
disbursement_date, daily_disbursements, and running_total.disbursement_date ascending.| Column | Type | Description |
|---|---|---|
| disbursement_idPK | INT | Unique identifier for the disbursement record |
| disbursement_date | DATE | Date on which the loan disbursement occurred |
| disbursement_amount | DECIMAL(12,2) | Amount disbursed for the record |