Question

In iSQL*Plus, you are given the following movie TITLE table:

TITLE
THE DAY THE EARTH STOOD STILL
THEM
THE TERMINATOR
WAR OF THE WORLDS
THE TIME MACHINE
GODZILLA: KING OF THE MONSTERS
THE CRAWLING EYE
THE TINGLER
THE MATRIX
THE ABYSS
THE HIDDEN
THE ANDROMEDA STRAIN
THE PINK PANTHER
A SHOT IN THE DARK

Select all titles that contain the word the. Please note: This is not a trick question – I mean the word ‘the’, not the letters: t h e. The following title does NOT contain the word the THERE IS A HOUSE ON A HILL. To simplify matters, you may presume that no movie is simply titled The, nor is the the last word in any title. Please use LIKE.

Answer 1

If you have any doubts, please give me comment...

SELECT TITLE

FROM movie

WHERE UPPER(TITLE) LIKE '% THE %' OR UPPER(TITLE) LIKE '% THE' OR UPPER(TITLE) LIKE 'THE %';