I have this structure
Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
Guest(guestNo, guestName, guestAddress)
Ho can I list hotels and rooms that were not reserved on "1-Mar-2022" ?
What i’ve done so far:
SELECT * FROM Hotel h, Room r, Booking b
WHERE h.hotelNo = r.hotelNo AND b.roomNo = r.roomNo
??? AND NOT (b.dateFrom and b.dateTo not contains ‘2022-03-01’) ???
>Solution :
You can use '2022-03-01' NOT BETWEEN b.dateFrom and b.dateTo