Write a query to find the top 10 users by total wager amount in the last 30 days for BetMGM.
Use the provided user and wager data. Include only wagers from the rolling 30-day period relative to the current date.
user_id, username, and total_wager_amountuser_id| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique BetMGM user identifier |
| username | VARCHAR(100) | User display name |
| registration_date | DATE | Date the user registered |
| Column | Type | Description |
|---|---|---|
| wager_idPK | INT | Unique wager identifier |
| user_id | INT | User who placed the wager |
| wager_amount | DECIMAL(12,2) | Wager amount in dollars |
| wager_date | DATE | Date the wager was placed |