Q6. (7) One of our guests staying at the resort in June 2017 requested information on our availability this year. I cant remember the name of the family, but I think they have a daughter; an unusual name but if I saw it, I would remember it. Find the guest number, the family name, the daughters name, and phone number of all guests matching this request. Q7. (5) How many biking trips over 8 miles were reserved in 2017? Label the output appropriately.

Code the queries in SQL Server and use the EERD below if needed.

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