Query Lesson 7. Between! Skipping values


#1

Can someone explain me if it is possible to do a "skip" (sorry, I do not know how it's called what I want to do),

In the example:

SELECT * FROM movies
WHERE name BETWEEN 'A' AND 'J';;

shows results from A to J (not included)

WHAT IF I want to exclude movies that begin with 'C'

Is there any command to do that?

I'm not sure if I have explained fine.

Thank you.


#2

SELECT * FROM movies
WHERE name BETWEEN 'A' AND 'J'
AND NOT name like 'C%';

#3

How did u get the yellow highlighted table?