Write a SQL query to calculate daily dock productivity by facility and rank the top-performing sites at XPO.
Use the provided facility and dock activity data. Exclude incomplete activity records and records with zero labor hours.
facility_id, facility_name, activity_date, completed_loads, labor_hours, productivity, and productivity_rank.| Column | Type | Description |
|---|---|---|
| facility_idPK | INT | Unique facility identifier |
| facility_code | VARCHAR(20) | Operational facility code |
| facility_name | VARCHAR(100) | Facility display name |
| region | VARCHAR(50) | Operating region |
| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique dock activity record |
| facility_id | INT | Referenced facility |
| activity_date | DATE | Date of dock activity |
| completed_loads | INT | Loads completed during the activity period |
| labor_hours | DECIMAL(10,2) | Dock labor hours recorded for the activity period |