Title	MovieId
Field of Dreams	104
Alien	105
Elizabeth	5022
Platoon	7442

Name	MovieId	DateRented
Randy Wolf	104	3-12-2006
Randy Wolf	5022	3-12-2006
Robert Person	107	3-12-2006

Title	DateRented
Field of Dreams	3-12-2006
Elizabeth	3-12-2006

  SELECT name, population, area, gdp
  FROM bbc
  WHERE name='Belarus'

  SELECT name, population, gdp
  FROM bbc
  WHERE region='Europe'
     OR region='Africa'

  SELECT name, area, population
  FROM bbc
  WHERE population>1000*area

  SELECT name, area
  FROM bbc
  WHERE region='Africa'
     AND (area<5000 OR area>1000000)

  SELECT title,score,votes
  FROM movie
  WHERE yr=1996
     AND score>=7.65

  SELECT title,yr
  FROM movie,actor
  WHERE name='Mel Brooks'
     AND movie.director = actor.id

  SELECT title
  FROM movie,actor,casting
  WHERE name='Mel Brooks'
     AND movie.director = actor.id
     AND movie.id = casting.movieid
     AND actor.id = casting.actorid

Here is the list of IDs for movies which include Dan Aykroyd:

    SELECT movieid
    FROM casting,actor
    WHERE name = 'Dan Aykroyd'
      AND casting.actorid=actor.id

Here is the complete SQL statement:

SELECT title, yr
FROM movie, casting, actor
WHERE name='Chevy Chase'
  and casting.actorid=actor.id
  and casting.movieid=movie.id
  and movie.id IN
   (SELECT movieid
    FROM casting,actor
    WHERE name = 'Dan Aykroyd'
      AND casting.actorid=actor.id)