Write a SQL query to find the top customers by order volume and revenue over the last 90 days.
Use the provided customers and orders tables. For deterministic evaluation, treat the 90-day period as December 31, 2024 through March 31, 2025, inclusive.
customer_id, customer_name, order_volume, and total_revenue.total_revenue descending, then order_volume descending, then customer_id ascending.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| customer_id | INT | Customer associated with the order |
| order_date | DATE | Date the order was placed |
| order_amount | NUMERIC(12,2) | Revenue attributed to the order |