02_queries_with_constraints_1.sql

-- 1. Find the movie with a row id of 6.

SELECT title
  FROM movies
 WHERE id = 6;

-- 2. Find the movies released in the years between 2000 and 2010.

SELECT title
  FROM movies
 WHERE year BETWEEN 2000 AND 2010;

-- 3. Find the movies not released in the years between 2000 and 2010.

SELECT title
  FROM movie
 WHERE year NOT BETWEEN 2000 and 2010;

-- 4. Find the first 5 Pixar movies and their release year.

SELECT title, year
  FROM movies
 WHERE year <= 2003;