4

Write the sol code for List names of guests who have booked a room at the Beachside Apartments on 13th October 2019. V test reservation RES_ID: int(11) # GUEST_ID = int(11) RES_CHECKIN:date a RES_CHECKOUT : date a RES_BOOKING_TIME: datetime V test room_booking RES_ID: int(11) a RM_ID: int(11) # RMBK_NUM_ADULTS: int(11) # RMBK_NUM_CHILD : int(11) # RMBK_DAILY_RATE: int(11) vo test room RM_ID: int(11) # HTL_ID : int(11) RM_TYPE: varchar(50) # RM_NUMBER : int(11) # RM_NUM_BEDS: int(11) # RM_DAILY_RATE: int(11) VO test guest GUEST_ID: int(11) @GUEST_FNAME: varchar(50) GUEST_LNAME : varchar(50) @ GUEST_EMAIL : varchar(50) @GUEST_PHONE: varchar(50) GUEST_ST_ADDRESS : varchar(50) GUEST_SUBURB : varchar(50) @GUEST_STATE: varchar(50) GUEST_COUNTRY: varchar(50) vo test hotel HTL_ID : int(11) @ HTL_NAME : varchar(50) HTL_SUBURB : varchar(50) HTL_CITY : varchar(50) @ HTL_COUNTRY : varchar(50) # HTL_STAR_RATING: int(11)