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 of the guests' cities, display the city name and countthe number of guests. Sort the answer with respect to the cityname, in descending order.
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 of the guests' cities, display the city name and countthe number of guests. Sort the answer with respect to the cityname, in descending order.