write an sql query for the following:
List the number (count) of unreserved rooms in each hotel i.e. rooms that have never been reserved.
List the guests by guest number, last name, first name and the number of times each guest has stayed in one of our hotels (include all reservations, past, current and future). Arrange the list in order from most-frequent stayer (greatest number of stays) to least-frequent stayer.