Write a SQL query to analyze weekly store performance at T-Mobile by joining sales, inventory, and staffing tables, and return the top stores by revenue, inventory shrink, and labor efficiency. Treat weeks as Monday through Sunday. Inventory shrink is expected units minus counted units, and labor efficiency is revenue divided by labor hours.
week_start, store_id, weekly_revenue, shrink_units, labor_efficiency, and the three rank columns.week_start, then store_id.| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| store_id | VARCHAR(10) | T-Mobile store identifier |
| sale_date | DATE | Date of sale |
| revenue | NUMERIC(12,2) | Revenue generated by the sale |
| Column | Type | Description |
|---|---|---|
| inventory_idPK | INT | Unique inventory snapshot identifier |
| store_id | VARCHAR(10) | T-Mobile store identifier |
| snapshot_date | DATE | Inventory count date |
| expected_units | INT | Units expected from inventory records |
| counted_units | INT | Units physically counted |
| Column | Type | Description |
|---|---|---|
| staffing_idPK | INT | Unique staffing record identifier |
| store_id | VARCHAR(10) | T-Mobile store identifier |
| shift_date | DATE | Staffing shift date |
| employee_count | INT | Number of employees assigned |
| labor_hours | NUMERIC(8,2) | Hours worked |