FROM A GUIDE TO SQL 9TH EDITION CHAPTER 5 COLONIAL ADVENTURE

FROM \'A GUIDE TO SQL\', 9TH EDITION, CHAPTER 5, COLONIAL ADVENTURE TOURS, QUESTIONS NEEDED ARE 1,3, 5, 7 AND 9, NUMBER

3. LIST THE TRIP NAME OF EACH TRIP THAT HAS MILES ABRAMS AS A GUIDE.,

NEED THE SQL IN BASIC FORM ONLY...THANKS

Solution

Considering TRIP as a table name having TRIP_NAME column which stores name of the trip, and GUIDE column which stores name of the guide.

below is the SQL query which will list all the trip names with the required details.

Select TRIP_NAME

from TRIP T

where T.GUIDE like \'%MILES ABRAMS%\'