Learn

Sometimes we want to combine multiple conditions in a WHERE clause to make the result set more specific and useful.

One way of doing this is to use the AND operator. Here, we use the AND operator to only return 90’s romance movies.

SELECT * FROM movies WHERE year BETWEEN 1990 AND 1999 AND genre = 'romance';
  • year BETWEEN 1990 AND 1999 is the 1st condition.

  • genre = 'romance' is the 2nd condition.

  • AND combines the two conditions.

AND Venn Diagram

With AND, both conditions must be true for the row to be included in the result.

Instructions

1.

In the previous exercise, we retrieved every movie released in the 1970’s.

Now, let’s retrieve every movie released in the 70’s, that’s also well received.

In the code editor, type:

SELECT * FROM movies WHERE year BETWEEN 1970 AND 1979 AND imdb_rating > 8;
2.

Remove the previous query.

Suppose we have a picky friend who only wants to watch old horror films.

Using AND, write a new query that selects all movies made prior to 1985 that are also in the horror genre.

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?