Using SQL Server Code... write a query that returns these statements...

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

2. Write an aggregate query to display the number of properties

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

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

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