Task 2 Queries with constraints

Question 1

Find the movie with a row id of 6

Answer 1

SELECT id, title FROM movies
WHERE id = 6;

Question 2

Find the movies released in the years between 2000 and 2010

Answer 2

SELECT title, year FROM movies
WHERE year BETWEEN 2000 AND 2010;

Question 3

Find the movies not released in the years between 2000 and 2010

Answer 3

SELECT title, year FROM movies
WHERE year < 2000 OR year > 2010;

Question 4

Find the first 5 Pixar movies and their release year

Answer 4

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