Write a SQL query to analyze guest check-in times and identify the busiest 30-minute intervals during peak holiday hours at Wynn Las Vegas.
Use the provided guest check-in and holiday peak-hour data. Include all intervals tied for the highest check-in volume.
interval_start, checkin_count, and busiest_rankinterval_start ascending| Column | Type | Description |
|---|---|---|
| checkin_idPK | INT | Unique guest check-in identifier |
| guest_id | VARCHAR(30) | Wynn Las Vegas guest identifier |
| checked_in_at | TIMESTAMP | Guest check-in timestamp |
| Column | Type | Description |
|---|---|---|
| holiday_datePK | DATE | Holiday operating date |
| holiday_name | VARCHAR(60) | Holiday or seasonal period name |
| peak_start | TIME | Beginning of the configured peak period |
| peak_end | TIME | Exclusive end of the configured peak period |