Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

9th Edition

0135188148, 978-0135188149, 9781642087611

More Books

Students also viewed these Databases questions

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago