2. (4 pts) List the trip ID and trip name for all trips that start in Bar Harbor

Question

2. (4 pts) List the trip ID and trip name for all trips that start in Bar Harbor. Your query should ignore the case of how Bar Harbor is entered in the query. For example, a trip with the start location of Bar Harbor should be included as should trips whose start location is BAR HARBOR, Bar harbor, BaR HarBor, and so on. Hint: Check out section "Character Functions" in your eBook and Figure 8-1 Cadillac Mountain Ride Cadilac Mountain Huguenot Head Hike Seal Beach Harbor 4 rows returned in 002 seconds Put your SQL command and results here: SELECT TRIPID. TRIP NAME FROM GUIDE WHERE TYPE(UPPER) BAR HARBOR -

Explanation / Answer

SELECT TRIP_ID, TRIP_NAME FROM GUIDE WHERE UPPER(START_TRIP)='BAR HARBOR';

-- WHERE START_TRIP IS THE COLUMN NAME FOR THE MATCHING FIELD (MAYBE IT COULD BE TRIP_NAME) Since the question doesn't include what are the fields in the given relation.

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.