Write a query using window functions to rank The Clorox top-performing retail partners by quarterly sales volume.
Use completed sales from calendar year 2025. Exclude sales without a matching retail partner and assign the same rank to partners tied on quarterly volume.
quarter_start, partner_id, partner_name, total_units, and quarterly_rank.| Column | Type | Description |
|---|---|---|
| partner_idPK | INT | Unique retail partner identifier |
| partner_name | VARCHAR(100) | Retail partner name |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sales transaction identifier |
| partner_id | INT | Retail partner associated with the sale |
| sale_date | DATE | Date of the sale |
| units_sold | INT | Number of units sold |
| status | VARCHAR(50) | Sales transaction status |