Given a table of daily sales across five different corporate cafes, write a query to find the top three performing cafes by week-over-week growth.
Use the most recent week in the data as the comparison week. Exclude cafes whose previous-week sales are zero or unavailable.
cafe_name, week_start, current_week_sales, prior_week_sales, and growth_pctcafe_name ascending as the tie-breaker| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique identifier for a daily cafe sales record |
| cafe_name | VARCHAR(100) | Corporate cafe name |
| sale_date | DATE | Date on which sales were recorded |
| sales_amount | DECIMAL(12,2) | Total sales recorded for the cafe on the date |