Q3. (6) List the first and last names and ages of all children at the resort in 2017, alphabetically by family name and oldest child first. List each child only once.

Q17. (7) The price of oats is forcing an increase in all horseback riding activities of 15%. Make the changes in the database first and then show the description and the new price of the activities. Show most expensive activity first.

Code these queries in SQL Server. Below is the EERD.

Family Adventure Resorts PERSONNE Name Name hone HOUSEKEEPING IKI CLEANING HKID FAMILIES CONDOS uesra Fna Condo GUIDES drms GUEST Fee LName CONDOSTAYS ACTIVITIES RESERVATIONS RID Guest AID TotalFeePaid] Hrs RDate Type TotalCost INVOICE INVOICEDETAILS Guest# RLName Departure Date] CondoFee] Details Totall Invoice Total SalesTax] Person Price] Activity Total Details Total Family Adventure Resorts PERSONNE Name Name hone HOUSEKEEPING IKI CLEANING HKID FAMILIES CONDOS uesra Fna Condo GUIDES drms GUEST Fee LName CONDOSTAYS ACTIVITIES RESERVATIONS RID Guest AID TotalFeePaid] Hrs RDate Type TotalCost INVOICE INVOICEDETAILS Guest# RLName Departure Date] CondoFee] Details Totall Invoice Total SalesTax] Person Price] Activity Total Details Total