Anonymous
public text v1 · immutableSELECT RoomNum
FROM Room
WHERE NOT EXISTS(SELECT 1 FROM Booking,BookingDetails,Room
WHERE BookingDetails.RoomNum = Room.RoomNum AND CURRENT_DATE BETWEEN Booking.ArrivalDate AND Booking.DepartDate);SELECT RoomNum
FROM Room
WHERE NOT EXISTS(SELECT 1 FROM Booking,BookingDetails,Room
WHERE BookingDetails.RoomNum = Room.RoomNum AND CURRENT_DATE BETWEEN Booking.ArrivalDate AND Booking.DepartDate);