Excellent! We have one more exercise for you before the end of this part. You are going to write your longest SQL query yet, and you'll apply knowledge from both of the parts you've mastered so far. Are you ready?
Select the Id, Title, and ProductionYear columns from the Movie table and the Name and BirthYear columns from the Director table such that each movie is shown together with its director. Show the BirthYear column as BornIn and the ProductionYear column as ProducedIn. Select only those movies:
'a' and that was filmed after 2000.or
Type:
SELECT
Movie.Id,
Movie.Title,
Movie.ProductionYear AS ProducedIn,
Director.Name,
Director.BirthYear AS BornIn
FROM Movie
JOIN Director
ON Director.Id = DirectorId
WHERE (
Movie.Title LIKE N'%a%'
AND Movie.ProductionYear > 2000
)
OR Director.BirthYear BETWEEN 1945 AND 1995;
