Find overlapping bookings for the same room.

Answer preview

Two half-open ranges overlap when each starts before the other ends: a.starts_on < b.ends_on AND b.starts_on < a.ends_on — the only rule you need to memorise.…