Use SQL to slove problem

Q8. (11) 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 in A104.

Q9. (7) Write a transaction script to store the following data: New guests, Martin & Trudy Winters from Mankato Minnesota will be staying at the resort the week starting October 21st, 2017. They have 2 children; son Trevor, who was 5 on June 2, 2017 and daughter Brooke, who turned 8 on Jan 15, 2017. They have not yet decided if they want to participate in any activities. We will assign them guest number G24 and place them in condo 5, A105. They can be reached at 218-555-5872. Check each table along the way to ensure that the data was entered correctly (include SQL to test). Use comments to explain what you are doing at each step. Show each record added.

Q10. (24) Retrieve all invoice data (including details) for the McLean family (see data required on ERD). They are challenging their total bill. Your final output will include all invoice data as shown on the ERD. Hint: Create a series of views keeping those attributes you need along the way; calculate the activity totals, then the invoice details totals, then the invoice condo fees, and finally the total billed. Do not hardcode; start with what you know.

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 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