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?