Can you write a SQL query to extract specific data from a dataset for a Curinos analytics use case?
Use analytics_accounts and account_transactions. Include active accounts and consider transactions dated from January 1 through March 31, 2025.
account_id, account_name, segment, total_transaction_amount, and transaction_count.total_transaction_amount descending, then account_id ascending.| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique account identifier |
| account_name | VARCHAR(100) | Account display name |
| segment | VARCHAR(50) | Account segment |
| status | VARCHAR(20) | Current account status |
| opened_on | DATE | Account opening date |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| account_id | INT | Referenced account identifier |
| transaction_date | DATE | Transaction posting date |
| amount | NUMERIC(12,2) | Signed transaction amount |
| transaction_type | VARCHAR(30) | Transaction classification |