Operations Analytics level task. **Condition:** Analyze the booking system's load by hours of the day and days of the week. Find peak hours. **Tables:** - appointments (appointment_date, ...) - screenings (start_time, ...) **Requirements:** 1. Combine data from both tables 2. Build a matrix: day of the week (1-7) × hour (0-23) → number of bookings 3. Highlight the top-5 busiest slots **Hint:** EXTRACT(DOW FROM ...) and EXTRACT(HOUR FROM ...) + GROUP BY.
Sign in to solve
Start Solving