Q8. (9) What are the names of the guides who led hiking trips over 1 hour long in 2017? Include their hire date and list the employees who have been employed the longest, first. Q9. (9) Find the first and last names of all the children who went on a rafting trip in July 2017 for more than 3 hours? List alphabetically by family name.

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