Intermediate SQL
Jasmin Ludolf
Data Science Content Developer, DataCamp
OR
, AND
, BETWEEN
SELECT *
FROM coats
WHERE color = 'yellow' OR length = 'short';
SELECT *
FROM coats
WHERE color = 'yellow' AND length = 'short';
SELECT *
FROM coats
WHERE buttons BETWEEN 1 AND 5;
OR
when you need to satisfy at least one conditionSELECT title
FROM films
WHERE release_year = 1994
OR release_year = 2000;
|title |
|-------------------------|
|3 Ninjas Kick Back |
|A Low Down Dirty Shame |
|Ace Ventura:Pet Detective|
...
SELECT title
FROM films
WHERE release_year = 1994 OR 2000;
argument of OR must be type boolean,
not type integer
LINE 3: WHERE release_year = 1994
OR 2000;
^
Use AND
if we need to satisfy all criteria
Correct:
SELECT title
FROM films
WHERE release_year > 1994
AND release_year < 2000;
|title |
|-----------------------------|
|Ace Ventura:When Nature Calls|
|Apollo 13 |
|Assassins |
|Babe |
...
SELECT title
FROM films
WHERE release_year > 1994 AND < 2000;
syntax error at or near "[removed]
1994 AND < 2000;
^
SELECT title
FROM films
WHERE (release_year = 1994 OR release_year = 1995)
AND (certification = 'PG' OR certification = 'R');
|title |
|----------------------|
|3 Ninjas Kick Back |
|A Low Down Dirty Shame|
|Baby's Day Out |
|Beverly Hills Cop III |
...
SELECT title
FROM films
WHERE release_year >= 1994
AND release_year <= 2000;
|title |
|-------------------------|
|3 Ninjas Kick Back |
|A Low Down Dirty Shame |
|Ace Ventura:Pet Detective|
|Baby's Day Out |
...
SELECT title
FROM films
WHERE release_year
BETWEEN 1994 AND 2000;
|title |
|-------------------------|
|3 Ninjas Kick Back |
|A Low Down Dirty Shame |
|Ace Ventura:Pet Detective|
|Baby's Day Out |
...
SELECT title
FROM films
WHERE release_year
BETWEEN 1994 AND 2000 AND country='UK';
|title |
|---------------------------|
|Four Weddings and a Funeral|
|The Hudsucker Proxy |
|Dead Man Walking |
|GoldenEye |
...
Intermediate SQL