American Express wants a simple monthly performance report for a card portfolio. Write a SQL query against a single table to summarize monthly portfolio results.
month in YYYY-MM formattotal_revenue as the sum of revenuetotal_charge_off as the sum of charge_off_amountnet_performance as SUM(revenue) - SUM(charge_off_amount)statement_date is NULL.| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique activity row identifier |
| portfolio_name | VARCHAR(100) | American Express portfolio name |
| statement_date | DATE | Statement or activity date |
| revenue | DECIMAL(12,2) | Revenue recognized for the activity row |
| charge_off_amount | DECIMAL(12,2) | Charge-off amount associated with the activity row |
| account_status | VARCHAR(20) | Status of the account segment |