Question
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
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.
1. List the last name of each guide that does not live in Massachusetts (MA).
2. List the trip name of each trip that has the type Biking.
3. List the trip name of
each trip that has the season Summer.
4. List the trip name of each trip that has the type Hiking and that has a distance longer
than 10 miles.
5. List the customer number, customer last name, and customer first name of each
customer that lives in New Je
rsey (NJ), New York (NY) or Pennsylvania (PA). Use the
IN operator in your command.
6. Repeat Exercise 5 and sort the records by state in descending order and then by
customer last name in ascending order.
7. How many trips are in the states of Maine (ME
) or Massachusetts (MA)?
8. How many trips originate in each state?
9. How many reservations include a trip price that is greater than $20 but less than
$75?
10. How many trips of each type are there?
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
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