Write a SQL query to find the top 10 most purchased items in the last month for Gametime United.
Use purchase records from the previous calendar month and count only completed purchases. Treat each completed purchase record as one item purchase.
item_id, item_name, and purchased_count.purchased_count descending, then item_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| item_idPK | INT | Unique identifier for a Gametime United item |
| item_name | VARCHAR(120) | Display name of the item |
| category | VARCHAR(60) | Item category |
| Column | Type | Description |
|---|---|---|
| purchase_idPK | INT | Unique purchase record identifier |
| item_id | INT | Purchased item identifier |
| purchased_at | DATE | Date on which the purchase was recorded |
| status | VARCHAR(20) | Purchase status |