Write SQL Queries Please Thank you!

Q1. 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/data 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