Im working on some practice questions for my oracle class and one is asking me to list all the hotel rooms that are vacant on june 4th 2006. i know i need to get all rooms and then subtract all the rooms booked on that date to return the vacant ones however i am having trouble getting the SQL right. could someone please help me out.

here is my table structrue

Hotel(hotel_no, name, address)
Room(room_no, hotel_no, type, price)
booking(hotel_no, guest_no, room_no, date_from, date_to)

i need to select hotel_no, room_no, date_from, and date_to

again this is prob pretty simple but i just started learning this after switching from access.

thanks
alex