(Solved) : Notel Ten 7 List Guest Names Stayed Holiday Inn July 4 2019 July 7 2019 Room Mha Sooeng Da Q41338992 . . .

NOTEL teN 7. List the guest names who stayed in Holiday Inn from July 4, 2019 to July 7, 2019. ROOM mha soOENG date m dna 8. i need help with number 7,8,9,10 pleaseNOTEL teN 7. List the guest names who stayed in Holiday Inn from July 4, 2019 to July 7, 2019. ROOM mha soOENG date m dna 8. Display the number of rooms for cach hotel. GUEST Please write SQL statement(s) in M SQL for cach exercise based on the above hotel database schema diagram. Copy and paste the statements in the colored box under each exercise 1. List the bookings for which the stay is longer than a week select From Booking where datediffdateTo,dateFrom)> 7 9. How many different guests have made bookings in year 2019? 2. What is the average price of a room for each hotel? 10. What is the total income from bookings for the Hilton Hotel this year? select hotelNo, avg(price) From room Show transcribed image text NOTEL teN 7. List the guest names who stayed in Holiday Inn from July 4, 2019 to July 7, 2019. ROOM mha soOENG date m dna 8. Display the number of rooms for cach hotel. GUEST Please write SQL statement(s) in M SQL for cach exercise based on the above hotel database schema diagram. Copy and paste the statements in the colored box under each exercise 1. List the bookings for which the stay is longer than a week select From Booking where datediffdateTo,dateFrom)> 7 9. How many different guests have made bookings in year 2019? 2. What is the average price of a room for each hotel? 10. What is the total income from bookings for the Hilton Hotel this year? select hotelNo, avg(price) From room

Expert Answer


Answer to NOTEL teN 7. List the guest names who stayed in Holiday Inn from July 4, 2019 to July 7, 2019. ROOM mha soOENG date m dn…