Answer Happy

Posted: **Tue Jul 12, 2022 8:21 am**

: 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 27 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.