Task 3 Queries with constraints (Pt. 2)

Question 1

Find all the Toy Story movies

Answer 1

SELECT title, director FROM movies
WHERE title LIKE “Toy Story%”;

Question 2

Find all the movies directed by John Lasseter

Answer 2

SELECT title, director FROM movies
WHERE director = “John Lasseter”;

Question 3

Find all the movies (and director) not directed by John Lasseter

Answer 3

SELECT title, director FROM movies
WHERE director != “John Lasseter”;

Question 4

Find all the WALL-* movies

Answer 4

SELECT * FROM movies
WHERE title LIKE “WALL-_”;