Room Booking Conflicts

A new booking for room 1 from 10:00 to 11:00 is requested. Return the number of existing bookings of that room that conflict with it.

Table schema

Bookings(id INT PRIMARY KEY, room INT, start_time TIME, end_time TIME)

Sample data

id | room | start_time | end_time
1 | 1 | 09:30 | 10:30
2 | 1 | 11:00 | 12:00
3 | 2 | 10:00 | 11:00