Write a SQL query to analyze daily guest complaints by property, category, and week at Caesars entertainment, and identify the top drivers of repeat complaints.
Use all available complaint records. A complaint is repeat when the same guest has previously complained at the same property and category. Treat Monday as the beginning of each week.
Output
- One row per property, category, week, and complaint date.
- Include
property_name, category_name, week_start, complaint_date, daily_complaint_count, daily_repeat_count, weekly_repeat_count, and driver_rank.
- Include all categories with complaints, order by property, week, category, and date, and assign tied drivers the same rank.
