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)
Question 3 (2 points)
Display the minimum, maximum, and average price per night forrooms of type 'Suite' in hotels located in the city of Chicago, andgive a short name for each of the requested output values.
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)
Question 3 (2 points)
Display the minimum, maximum, and average price per night forrooms of type 'Suite' in hotels located in the city of Chicago, andgive a short name for each of the requested output values.