Consider a database with the following relations: Hotel (Hotel ID, H_Name, H_Address, H_City, Maximum_Capacity) Gues
Posted: Tue Jul 12, 2022 8:17 am
Consider a database with the following relations:
Hotel (Hotel ID, H_Name, H_Address, H_City,Maximum_Capacity)
Guest (Guest_ID, G_Name, G_Address, G_City)
Room (Hotel_ID, Room_Number, Type,Price_Per_Night)
Booking (Guest_ID, Hotel_ID, Room_Number, From_Date,To_Date, Number_of_Nights)
For each room type in "Chicago" located hotels, display the typeand the hotel's name in the descending order of the type.
We are interested only in the types with an average price pernight of 120$ or more.
Hotel (Hotel ID, H_Name, H_Address, H_City,Maximum_Capacity)
Guest (Guest_ID, G_Name, G_Address, G_City)
Room (Hotel_ID, Room_Number, Type,Price_Per_Night)
Booking (Guest_ID, Hotel_ID, Room_Number, From_Date,To_Date, Number_of_Nights)
For each room type in "Chicago" located hotels, display the typeand the hotel's name in the descending order of the type.
We are interested only in the types with an average price pernight of 120$ or more.