Use Workbench/Command Line to create the commands that will run the

following queries/problem scenarios. Use MySQL and the Colonial Adventure Tours database to complete the following

exercises.

11. Colonial Adventure Tours calculates the total price of a trip by adding the trip price

plus other fees and multiplying the result by the number of persons included in the

reservation. List the reservation ID, trip ID, customer number, and total price for all

reservations where the number of persons is greater than four. Use the column name

TOTAL_PRICE for the calculated field.

12. Find the name of each trip containing the word Pond.

13. List the guides last name and guides first name for all guides that were hired before June 10, 2013.

14. What is the average distance and the average maximum group size for each type of

trip?

15. Display the different seasons in which trips are offered. List each season only once.

16. List the reservation IDs for reservations that are for a paddling trip. (Hint: Use a subquery.)

17. What is the longest distance for a biking trip?

18. For each trip in the RESERVATION table that has more than one reservation, group

by trip ID and sum the trip price. (Hint: Use the COUNT function and a HAVING clause.)

19. How many current reservations does Colonial Adventure Tours have and what is the

total number of persons for all reservations?

File Home External Data Database Tools Help Fields TableTell me what you want to do Form Wizard NavigationReport Report Blank Labels MOdule Report Wizard | Table Table SharePointQuery Query Macro Class Module Application Parts Templates Visual Basic Design Form More Foms Wizard Design Queries Macros & Code All Access Obje