Home / Expert Answers / Computer Science / prepare-sql-queries-to-retrieve-the-infromation-nbsp-1-for-cabin-rental-customers-what-is-the-pa684

(Solved): Prepare SQL Queries to retrieve the infromation.   1. For cabin rental customers, what is the ...



Prepare SQL Queries to retrieve the infromation.

 

1. For cabin rental customers, what is the average length of stay?


2. How frequently are watercrafts rented? On average, what is the length of rental time?


3. Which boat slip rental option is the most popular? What is the rental revenue by rate
code?


4. How much revenue did Mr. Mackenzie receive on fishing boat rental fees last week?
Last month? Jet skis? (Use the last week in July for the weekly analysis.)

5. On average, how much does a customer spend on each visit?

Customer

 

 

 

 

Property

 

Rate

 

Reservation \( x \)

 

Customer Property Rate Reservation \( x \)


We have an Answer from Expert

View Expert Answer

Expert Answer


SOLUTION 1 SELECT AVG(DATEDIFF(day, ResDate, EndDate)) FROM Reservation where exists (SELECT *from Property
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe