Page 1 of 1
Quiz2 (10P) Consider a database with the following relations: Hotel (Hotel ID, H_Name, H_Address, H_City, Maximum_Capaci
Posted: Tue Jul 12, 2022 8:21 am
by answerhappygod
- Quiz2 10p Consider A Database With The Following Relations Hotel Hotel Id H Name H Address H City Maximum Capaci 1 (68.84 KiB) Viewed 33 times
Quiz2 (10P) 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) Build the following queries in SQL.
Question 1 (1 point) Display available Hotels (by ID, Name, and address) in the City of Chicago with a maximum capacity between 1000 (included) and 1500 (included). Display the results in ascending order with respect to the ID. Paragraph V B I UA E E OB 2⁰ + v ...