HOW TO DO THIS DATABASE QUESTION USINGORACLE? PLEASE MAKE SURE TO RUN IT TO CHECKOUTPUT
Hotel (hotelNo, hotelName, hotelAddress,country)
Room (roomNo, hotelNo, type,price)
Guest (guestNo, guestName, guestAddress,country)
Booking (hotelNo, guestNo,dateFrom, dateTo, roomNo)
- (a). List hotelNo, hotelName and LostIncome, in hotelNo order.Of all Unoccupied rooms at each hotel today. Use 2019-02-05 astoday’s date.
(b).What is the average number ofbookings for each hotel in month of 2019-02.
Expert Answer
An answer will be send to you shortly. . . . .