Task level: Booking/Airbnb. **Condition:** Find all pairs of reservations for the same room that overlap in dates (conflicts). **Table:** reservations (reservation_id, room_id, check_in_date, check_out_date, status, ...) **Requirements:** 1. Only consider active reservations (status IN ('confirmed', 'checked_in')) 2. Reservations overlap if: A.start < B.end AND A.end > B.start 3. Output room_id, reservation1_id, reservation2_id, overlap_start, overlap_end, overlap_days **Sub
Sign in to solve
Start Solving