Running Total Transactions Query | Dataford Interview Questions

Kabbage needs a daily view of posted transaction activity for its Kabbage Funding product. Write a PostgreSQL query that aggregates transaction amounts by day and calculates the cumulative transaction amount over time.

Requirements

Include only transactions for Kabbage Funding accounts with a posted status.
Exclude transactions whose account does not exist in accounts.
Return one row per transaction date with daily totals and a running total ordered chronologically. Treat a NULL amount as zero.

Schema

accounts

Column	Type	Description
account_idPK	INT	Unique account identifier
account_name	VARCHAR(100)	Business account name
product_name	VARCHAR(50)	Kabbage product associated with the account

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
account_id	INT	Account associated with the transaction
transaction_date	DATE	Date the transaction was recorded
amount	DECIMAL(12,2)	Transaction amount
status	VARCHAR(20)	Transaction processing status

Your question is Running Total Transactions Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem