Using the Rentals Database do the following:

Write a query that returns all guests from the state/province of Illionois or Indiana

Write an update statement that changes Guest 209s last name to your last name

Write a query that returns all reservations with a rental rate that is less than 2000

Write a query that displays the minimum, maximum, and average rental rate

Write a query that displays the Reservationid, guestid, Propertyid, and the cost per person for each reservation.

Write an aggregate query to display the number of properties

Write an aggregate query that displays a count of distinct states

Create a new table named Propertybackup that contains all properties that sleeps more than 10 people.

Insert the rest of the records from the properties table into the Propertybackup table

Display personnels firstname, lastname, title, and manager name.

tblGuest Y Guest ID Guest First Name Guest LastName ddress City State Pro PostalCode Country Phone tblReservation ReservationID TAT Guest ID PropertyID Start Date End Date People tblProperty V PropertyID Property Name Location Country Nightly Rate Bedrooms Sleeps Property Type Description tblPersonnel Pers onID First Name LastName JobTitle Manager 1 tblWork Property ID Pers onID