Write a SQL query to analyze operational performance by joining guest satisfaction, staffing, and occupancy data to identify the biggest drivers of service issues.
Use the three daily operational tables provided. Calculate service issue rates and compare staffing gaps with occupancy levels for operational days having complete, valid measurements.
Output
- One row per property and operational driver.
- Columns:
property_id, driver_name, high_driver_issue_rate, low_driver_issue_rate, issue_rate_lift, and driver_rank.
- Include staffing-gap and occupancy-rate drivers, rank within each property by descending issue-rate lift, and break ties alphabetically by driver name.
