Consider the following Hotel Room, Booking and Guest schera in Dams. The hotel is the primary Wey for Hotel table and ro

[answerhappygod]

Consider The Following Hotel Room Booking And Guest Schera In Dams The Hotel Is The Primary Wey For Hotel Table And Ro 1 (13.7 KiB) Viewed 40 times

Consider the following Hotel Room, Booking and Guest schera in Dams. The hotel is the primary Wey for Hotel table and room is the primary key for the Room relation Booking stores the details of room reservations and bookingNo is the primary key, Guest stores the guests details and guest is the primary key. Hool (hotel, hotelName, hoteltype, hotelAddress, hotelCity, numRoom Room croon, hotel roomPrice) for booking hotel questo checkin checkout, totalGuestroomNo) Guest est firstName.lastName Address Write the followin SQL Statements 01: Write the SOL to list the names of all the hotels in Al Ain 12: Write the SOL to show the total number of hotels in Abu Dhabi Write the SQL to list the names of all hotels, which have rooms of price cheaper than 400 dirhams: Write the SOL to show the average hotel room price in each city.