Question

3.8.7: select movie titles with like. the given sql creates a movie table and inserts some movies. the select statement selects all movies. modify the select statement to select movies with the word 'star' somewhere in the title. run your solution and verify the result table shows just the movies rogue one: a star wars story, star trek and stargate.

Answer 1

Modify the select statement to select movies with the word 'star' somewhere in the title:

SELECT title

FROM movie

WHERE title LIKE '%star%';

What is word?
Word is a unit of language that typically consists of one or more spoken sounds or their written representation that functions as a principal carrier of meaning. Word can also refer to a short phrase or expression.

It is the smallest unit of language that can be uttered in isolation with semantic or pragmatic content.

To learn more about word
https://brainly.com/question/20659068
#SPJ4

Answer 2

Modify the select statement to select movies with the word 'star' somewhere in the title:

SELECT title

FROM movie

WHERE title LIKE '%star%';

What do you mean by word?

A word is a linguistic construction that normally consists of one or more uttered sounds or their written equivalents and serves as the main signifier of meaning. Word can also be used to describe a brief sentence or expression.

According to the given question,

It is the smallest unit of language that can be uttered in isolation with semantic or pragmatic content.

Therefore, the modify the select statement to select movies with the word 'star' somewhere in the title:

SELECT title

FROM movie

WHERE title LIKE '%star%';

To learn more about word, visit:

brainly.com/question/20659068

#SPJ4