Write a SQL query to find the top-performing retail stores by sales growth over the last quarter.
Assume the last completed quarter is 2025-01-01 through 2025-03-31, compared with the preceding quarter, 2024-10-01 through 2024-12-31. Return stores with sales in both quarters and exclude stores whose preceding-quarter sales are zero.
store_id, store_name, prior_quarter_sales, last_quarter_sales, and sales_growth_pct.store_id ascending for ties.| Column | Type | Description |
|---|---|---|
| store_idPK | INT | Unique retail store identifier |
| store_name | VARCHAR(150) | Retail store name |
| region | VARCHAR(50) | Geographic sales region |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sales transaction identifier |
| store_id | INT | Retail store associated with the sale |
| sale_date | DATE | Date of the recorded sale |
| amount | NUMERIC(12,2) | Sales amount in dollars |
| sales_channel | VARCHAR(30) | Channel where the sale was recorded |