how can you add the LIKE command to additional commands such as the example below? I would like to search only the titles (which the of column was originally “name”) that include the word THE in them
SELECT name as ‘titles’, imdb_rating as ‘alex’, year as ‘john’
FROM movies
WHERE imdb_rating > 7 and year > 2000 and genre = ‘action’;