Consider A Database With The Following Relations Guest Guest Id G Name G Address G City Room Hotel Id Room Numbe 1 (33.16 KiB) Viewed 26 times
Consider a database with the following relations: 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) Build the following queries in SQL.
for each of the guests' cities, display the city name and count the number of guests. Sort the answer with respect to the city name, in descending order.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!