Nice! Let's put into practice everything we've learned so far. Are you ready? This example is going to be slightly more complicated, so make sure you remember everything from this part of the course.
Select the title and production_year columns from the movie table, and the name and birth_year columns from the director table in such a way that a movie is shown together with its director.
Show the column birth_year as born_in. Select only those movies which were filmed when their director was younger than 40 (i.e. the difference between production_year and birth_year must be less than 40).
Type:
SELECT title, production_year, name, birth_year AS born_in FROM movie JOIN director ON director_id = director.id WHERE (production_year - birth_year) < 40;
