Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Use Exists to find reservation ID, trip ID, and trip date for reservations for a trip in New Hampshire (NH). 2. Find the guide
1. Use Exists to find reservation ID, trip ID, and trip date for reservations for a trip in New Hampshire (NH). 2. Find the guide last name and guide first name of all guides who can lead a paddling trip. 3. Find the trip ID and trip name for each trip whose maximum group size is greater than the maximum group size of every trip that has the type Hiking. 4. Find the trip ID and trip name for each trip whose maximum group size is greater than the maximum group size of at least one trip that has the type Biking. 5. Calculate the total revenue for each trip. Total revenue is calculated as number of persons times trip prices plus other fees. 6. Use the formula in question 5 to find total revenue and average revenue for each guide. 7. Who are the customers participated in a summer trip with a guide Called Zach Gregory
Step 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