HOW TO DO THIS DATABASE QUESTION USING ORACLE? PLEASE MAKE SURE TO RUN IT TO CHECK OUTPUT

Hotel (hotelNo, hotelName, hotelAddress, country)

Room (roomNo, hotelNo, type, price)

Guest (guestNo, guestName, guestAddress, country)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

1. (a). List the hotelNo, roomNo order of all the rooms at Grosvenor hotels, including name of guest staying in the room if the room is Occupied. Use 2019-02-05 as todays date.

(b). List the hotelNo, roomNo order of all the Unoccupied rooms at Grosvenor hotels, Use NOT IN to perform the difference operation.Use 2019-02-05 as todays date.

(c). List the hotelNo, roomNo order of all the Unoccupied rooms at Grosvenor hotels, Use NOT EXISTS to perform the difference operation. Use 2019-02-05 as todays date.

(d). List the hotelNo, roomNo order of all the Unoccupied rooms at Grosvenor hotels, Use LEFT JOIN to perform the difference operation. Use 2019-02-05 as todays date.

(e). List the hotelNo, roomNo order of all the Unoccupied rooms at Grosvenor hotels, Use MINUS to perform the difference operation. Use 2019-02-05 as todays date.