--Q7.
SELECT Room.roomNo, Room.hotelNo, Room.price, Room.type
FROM Room
LEFT OUTER JOIN Booking
ON Room.hotelNo = Booking.hotelNo
AND Room.roomNo = Booking.roomNo
WHERE Room.hotelNo = 1
AND Room.roomNo IN(SELECT Room.roomNo
FROM Room
MINUS
SELECT Booking.roomNo
FROM Booking
WHERE Booking.dateFrom <= '2015-02-01' AND (Booking.dateTo >= '2015-02-01' OR Booking.dateTo IS NULL)
AND Booking.hotelNo = 1
)
ORDER BY roomNo ASC;