Write SQL Queries Please

Q1. How much money did each guest spend on activities in 2017? Include the guest's last name and Money Spent on Activities. Include only those guests spending at least $240.00. Display the highest values first. Q2. Write a fully nested query to display those guides who lead activities that are more than 10 miles. List their first and last name and years employed by the resort. Store the result in Ten_Mile_Guides. Display the data by the employee who has been with the resort the shortest amount of time first. Q3. Write a combination join and nested query to: List all activities that any guest of A104 participated. Housekeeping found a snake in the condo and are trying to figure out how it may have gotten there. List the date of the activity as well. Label the activity description, Activities for Families Staying in A104.

PERSONNEL ame ame redate Type signedCondos CLEANING KID AMILIES CONDOS elationship GUIDES hdate Agel nitNum qrFt drms aths VeeklyFee GUESTS CONDOSTAYS pouseFName Guest# RESERVATIONS ACTIVITIES ndDate otalFeePaid escription ID ID ate lumberinParty otalCost ype