#p1
SELECT *
FROM `actors`
WHERE first_name = "Julia";

#p2
SELECT id
FROM movies
WHERE year BETWEEN 1995 AND 2000;

#p3
SELECT actor_id
FROM `roles`
WHERE movie_id = 112290;

#p4
SELECT roles.role
FROM roles
INNER JOIN movies ON roles.movie_id=movies.id
WHERE movies.name="Pi";

#p5
SELECT actors.first_name,actors.last_name,roles.role
FROM roles
INNER JOIN movies ON roles.movie_id=movies.id
INNER JOIN actors ON roles.actor_id = actors.id
WHERE movies.name="Pi";

#p6
SELECT DISTINCT a.first_name, a.last_name
FROM actors a
INNER JOIN roles r1 ON r1.actor_id = a.id
INNER JOIN movies m1 ON r1.movie_id = m1.id
INNER JOIN roles r2 ON r2.actor_id = a.id
INNER JOIN movies m2 ON r2.movie_id = m2.id
WHERE m1.name = "Kill Bill: Vol. 1" AND m2.name = "Kill Bill: Vol. 2";