You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
8 lines
334 B
SQL
8 lines
334 B
SQL
/*17. Write a query in SQL to list all the actors who acted in a movie before 1990 and also in a movie after 2000.*/
|
|
SELECT act_fname, act_lname, mov_title, mov_year
|
|
FROM actor
|
|
JOIN movie_cast
|
|
ON actor.act_id=movie_cast.act_id
|
|
JOIN movie
|
|
ON movie_cast.mov_id=movie.mov_id
|
|
WHERE mov_year NOT BETWEEN 1990 and 2000; |