Q1. (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. Q2. (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. Q3. (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.

Q4. (1) 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 employee who has been with the resort the shortest amount of time first. Thanks!!

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