(Solved) : Database Question Using Oracle Hotel Hotelno Hotelname Hoteladdress Country Room Roomno Ho Q34314024 . . . .

HOW TO DO THIS DATABASE QUESTION USING ORACLE?

Hotel (hotelNo, hotelName, hotelAddress,country)
Room (roomNo, hotelNo, type, price)
Guest (guestNo, guestName, guestAddress,country)
Booking (hotelNo, guestNo,dateFrom, dateTo, roomNo)

1. (a). Do this for each hotel and in one single query. List thetotal revenue with the hotelName, and only if the total revenue isbetween $500 to $1000 [in SQL context]. List in hotelNameorder.

(b). List the type and price of all rooms at the hotels with’Grosvenor’ in name, including the number of rooms for eachpossible combination of type and price. List only if the number ofrooms for each type and price combination is greater than 3. [Note:Consider which