First table 'Booking' contains From_date, To_date, and Room_ID.
Second table 'Room' contains Room_ID and a random column Room_Floor.
Booking From_date || To_date || Room_ID Room Room_ID || Room_Floor
a) What query would result in booked rooms that are in the 1st floor, from a specific date to a specific one.
b) What query would result in available rooms that are in 2nd floor for example, from a specific date to a specific one.
Thank you in advance. Any help is greatly appreciated.
Using MS SQL 2008.