Your question is Reconcile Monthly Activity by Account. Start with the requirements and the one table 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.
UC Davis Financial Services wants a simple reconciliation view from Aggie Enterprise export data. Write a SQL query to summarize posted financial activity by account for March 2024.
account_code.status = 'Posted' and transaction_date is in March 2024.SUM(debit_amount) - SUM(credit_amount)net_activity descending, then account_code ascending.| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| account_code | VARCHAR(20) | General ledger account code |
| account_name | VARCHAR(100) | General ledger account description |
| transaction_date | DATE | Date the transaction was posted or recorded |
| debit_amount | DECIMAL(12,2) | Debit amount on the transaction |
| credit_amount | DECIMAL(12,2) | Credit amount on the transaction |
| status | VARCHAR(20) | Transaction status such as Posted or Pending |
| source_system | VARCHAR(50) | System where the transaction originated |