In each of the following queries, use SQL to obtain the desired results using the data shown in the Colonial Preview the documentAdventure Tour DatabasePreview the document 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 the trip name and state for each trip that occurs during one of the Fall seasons that is Early Fall, Spring and Late Fall. Sort by State. Use the wildcard for the season.
SELECT TripName, State
FROM Trip
WHERE Season
State;
Answer 1:
='Spring'
Answer 2:
ORDER BY TripName,
Give the SQL statement to display the number of trips that originate in Vermont (VT) or Connecticut (CT)??
SELECT
FROM Trip
WHERE ;
Answer 1:
COUNT(*)
Answer 2:
State='VT' or State='CT'
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 ;
Answer 1:
COUNT(*)
Answer 2:
Reservation
Answer 3:
>= 20 AND TripPrice <= 50​​​​​​​