In each of the following queries, use SQL to obtain the desired results using the data shown in the Colonial Adventure Tour Database listing found on the homepage under the databases heading. Also, found there is a file containing the SQL commands needed to create the database in a DBMS such as MySQL. You might want to create the database to use when answering the questions. If so, just copy the commands and paste them into MySQL.

You will have 3 attempts to get the activity correct and the computer will automatically grade your answers after each attempt. When an answer consists of more than one word be careful about spacing. Leave only one space between words and ooperators.

Give the SQL statement to list TripId, TripName, Type, and Season from the table Trip.

SELECT TripId, , Type, Season FROM ;

Give the SQL statement to list TripID, TripDate, TripPrice from the table Reservation.

SELECT TripID, TripDate, TripPrice FROM ;

Give the SQL statement to list all the attributes (fields) from the table Trip. Use the symbol that indicates all attributes from the table.

SELECT FROM ;

Give the SQL statement to list the name of each trip that does not start in New Hampshire (NH).

SELECT FROM WHERE State 'NH';

Give the SQL statement to list the last name of each guide that lives in Maine (ME).

SELECT LastName FROM WHERE State = ; Give the SQL statement to list the name and start location for each trip that has the type Biking.

SELECT TripName, FROM Trip WHERE ;

Give the SQL statement to list the name of each trip that has the type Hiking and that has a distance of greater than six miles.

SELECT TripName FROM WHERE Type = 'Hiking' Distance ;

Give the SQL statement to list the name of each trip that has the type Paddling or that is located in Vermont (VT).

SELECT TripName FROM Trip WHERE Type = 'Paddling' State ;

Give the SQL statement to display the number of trips that have a type of Hiking or Biking?

SELECT FROM Trip WHERE Type IN ;

Give the SQL statement to list the trip name and state for each trip that occurs during one of the Spring seasons that is Early Spring, Spring and Late Spring. Sort by State. Use the wildcard for the season.

SELECT TripName, State FROM Trip WHERE Season State;

Give the SQL statement to display the number of trips that originate in Vermont (VT) or Connecticut (CT)??

SELECT FROM Trip WHERE ;

Give the SQL statement to display the number of reservations that include a trip with a price that is greater than or equal to $20 but less than or equal to $50.

SELECT FROM WHERE TripPrice ;