(Solved) : Write Sol Code List Hotel Names Total Number Rooms Hotel Indonesia Vo Test Reservation Res Q43974544 . . .
Write the sol code for List the hotel names and the total number of rooms in each hotel in Indonesia. vo test reservation RES_ID: int(11) # GUEST_ID : int(11) RES CHECKIN: date RES_CHECKOUT : date RES_BOOKING_TIME: datetime V 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) 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 t est 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) Show transcribed image text Write the sol code for List the hotel names and the total number of rooms in each hotel in Indonesia. vo test reservation RES_ID: int(11) # GUEST_ID : int(11) RES CHECKIN: date RES_CHECKOUT : date RES_BOOKING_TIME: datetime V 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) 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 t est 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)
Expert Answer
Answer to Write the sol code for List the hotel names and the total number of rooms in each hotel in Indonesia. vo test reservatio…
OR