Database Management

T-Mobile 12:35 PM ecourses.pvamu.edu IL. Given test2DB set up, please answer to the following questions. You can reference chapter 6 slides on Ecourses. Please write proper SQL statement for each request and show the result of the query execution. Please copy and paste the sql statements and resultant tables from mysql running terminal List all details of king or family rooms with a price more than $700 per night, in ascending order of price. (15 pts) c) How many different guests have made bookings for November 2018? One column. Display the total number of guests, Make the column name as NovemberGuestNum') (15 pts) g) List the number of rooms of each hotel in room table. (two columns-hNo, roomCount) (15 pts) )List names of all guest along with the dateFrom, date To and hotel name, who have booked a hotel which is located itn houston'-(20 pts) s Update the address of guest Mary" to 777 Prairie'. Display all records of guest table after update. (10 pts) ) List hotels and booking information along with any unmatched hotels. Display all details of hotel and booking dateFrom date To and rNo. The unmatched hotels should be filled with Null for the missing columns.) (23 pts)