Write a SQL query to join three tables and identify the top 10 users by usage volume. Use the supplied tables and aggregate valid usage records for each user.
user_id, user_name, and total_usage.total_usage descending and user_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| user_name | VARCHAR(100) | User display name |
| user_status | VARCHAR(20) | Current account status |
| Column | Type | Description |
|---|---|---|
| usage_idPK | INT | Unique usage record identifier |
| user_id | INT | User associated with the usage |
| service_id | INT | Service associated with the usage |
| usage_units | INT | Measured usage volume |
| usage_type | VARCHAR(30) | Usage measurement category |
| Column | Type | Description |
|---|---|---|
| service_idPK | INT | Unique service identifier |
| service_name | VARCHAR(100) | Service name |
| service_status | VARCHAR(20) | Current service status |