Find Overlapping Date Ranges
Given a table bookings (room_id, start_date, end_date), list all pairs of bookings that overlap for the same room.
These are the tables to query for this question:
bootcamp.bookingsYour answer should include these columns:
- room_id integer
- booking1 integer
- booking2 integer
- overlap_start date
- overlap_end date
Querying is only for logged in users!
Sign In