Your question is Running Total Transactions Query. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
posted status.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 |
| 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 |