Question

Partial Question 10 1/2 pts 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 LIKE '%Fall' OR SEA ORDER BY State: Answer 1: LIKE '%Fall' OR SEASON LIKE 'Spring' Answer 2: ORDER BY Partial Question 11 1/2 pts Give the SQL statement to display the number of trips that originate in Vermont (VT) or Connecticut (CT)?? SELECT Count(TripName) FROM Trip WHERE State='VT OR State Answer 1: COUNT(TripName) Answer 2: State='VT' OR State='CT'

Answer 1

Solution:

-- When there is no wildcard operator, no need to use LIKE operator

-- For season spring

SELECT TripName, State FROM Trip

WHERE Season LIKE '%Fall' OR Season = 'Spring'

ORDER BY State;

-- It is advised to use primary column i.e. TripId rather than TripName

-- Use column name alias for resulted column

-- Use IN operator

SELECT COUNT(TripId) AS NumberOfTrips FROM Trip WHERE State IN('VT','CT');

-- It is advised to use primary column i.e. ReservationID rather

-- Use column name alias for resulted column

-- Use >= and <= properly, you just mentioned >.

SELECT COUNT(ReservationID) AS NumberOfReservations FROM Reservation WHERE TripPrice >= 20 AND TripPrice <=50;

-- or Use Between operator

SELECT COUNT(ReservationID) AS NumberOfReservations FROM Reservation WHERE TripPrice BETWEEN 20 AND 50;

When there is no wildcard operator, no need to use LIKE operator -- For season spring SELECT TripName, State FROM Trip WHERE Season LIKE '%all' OR Season = 'Spring' ORDER BY State; -- It is advised to use primary column i.e. TripId rather than TripName -- Use column name alias for resulted column -- Use IN operator SELECT COUNT(TripId) AS NumberOfTrips FROM Trip WHERE State IN ('VI','CT'); It is advised to use primary column i.e. ReservationID rather -- Use column name alias for resulted column -- Use >= and <= properly, you just mentioned >. SELECT COUNT(ReservationID) AS NumberOfReservations FROM Reservation WHERE TripPrice >= 20 AND TripPrice <=50; or Use Between operator SELECT COUNT(ReservationID) AS NumberOfReservations FROM Reservation WHERE TripPrice BETWEEN 20 AND 50;

******************************************************************************

Feel free to rate the answer and comment your questions, if you have any.

Please upvote the answer and appreciate our time.

Happy Studying!!!

******************************************************************************