Write a SQL query to find the top 3 customers with the highest data usage per month over the last year at Vodafone. Use the provided Vodafone customer, account, and usage data. Include months represented by qualifying usage records during the trailing 12-month period.
usage_month, customer_id, customer_name, total_data_usage_mb, and monthly_rank.usage_month, then monthly_rank, then customer_id. Break equal usage totals by the lower customer_id.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique Vodafone customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique mobile account identifier |
| customer_id | INT | Customer who owns the account |
| account_number | VARCHAR(30) | Vodafone account reference |
| Column | Type | Description |
|---|---|---|
| usage_idPK | INT | Unique usage record identifier |
| account_id | INT | Account that generated the usage |
| usage_date | DATE | Date of recorded data usage |
| data_usage_mb | NUMERIC(12,2) | Data consumed in megabytes |
| session_status | VARCHAR(20) | Usage session status |