We can restrict our query results using the WHERE
clause in order to obtain only the information we want.
Following this format, the statement below filters the result set to only include top rated movies (IMDb ratings greater than 8):
SELECT * FROM movies WHERE imdb_rating > 8;
How does it work?
The
WHERE
clause filters the result set to only include rows where the following condition is true.imdb_rating > 8
is the condition. Here, only rows with a value greater than 8 in theimdb_rating
column will be returned.
The >
is an operator. Operators create a condition that can be evaluated as either true or false.
Comparison operators used with the WHERE
clause are:
=
equal to!=
not equal to>
greater than<
less than>=
greater than or equal to<=
less than or equal to
There are also some special operators that we will learn more about in the upcoming exercises.
Instructions
Suppose we want to take a peek at all the not-so-well-received movies in the database.
In the code editor, type:
SELECT * FROM movies WHERE imdb_rating < 5;
Ouch!
Edit the query so that it will now retrieve all the recent movies, specifically those that were released after 2014.
Select all the columns using *
.