Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q10. (5) What was the average revenue of all condo rentals in 2017? Show the value with 2 decimal places. Label the output, Average Revenue
Q10. (5) What was the average revenue of all condo rentals in 2017? Show the value with 2 decimal places. Label the output, Average Revenue for Condo Rentals in 2017. Q11. (7) We found some personal property that must be returned to one of our guests. Which guests stayed in condo 10 in 2017? Find the registered first name, family name and phone number. Show the results 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 TotalStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started