I'm building a small database to track rooms at an Inn. I have one table that tracks bookings which includes the room booked and the start and end date of the booking. I have another table that lists all the rooms. I would like one more table that either lists all the rooms that are currently booked, or one that lists all the rooms excluding those booked.
This doesn't have to work well in a real life application, it just has to kind of work.