Question: Write the sql code for List the room numbers that are currently occupied at Holiday Inn Express. Vo t est reservation RES_ID: int(11) # GUEST_ID:

 Write the sql code for List the room numbers that are

Write the sql code for List the room numbers that are currently occupied at Holiday Inn Express. Vo t est reservation RES_ID: int(11) # GUEST_ID: int(11) RES_CHECKIN: date RES_CHECKOUT : date RES_BOOKING_TIME: datetime Vo test room_booking RES_ID: int(11) 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) 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) V 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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!