Consider the HOTEL database used in the SQL in-class discussions

Hotel (hotelNo, hotelName, city)

Room (roomNo, H_hotelNo, roomType, price)

Booking (H_hotelNo, G_guestNo, dateFrom, dateTo, R_roomNo)

Guest (guestNo, guestName, guestAddress)

c. Give a relational algebra expression and a SQL query for the following English statement:

List the room number and corresponding room type for rooms available in June 13th or August 23rd of this year at the Hilton in Seattle.