How to query more than one table
Creating JOINs
Referencing columns
10. Filter the joined tables
Let's practice

## Instruction

Amazing job! Now that we know how to work with columns, let's find out how to filter the results even further:

SELECT
person.id,
car.model
FROM person
JOIN car
ON person.id = car.owner_id
WHERE person.age < 25;


The new part here is the WHERE clause. Now we only look for such connections of cars and their owners where the owner is below 25. Be sure to include the table name in the condition (person.age).

## Exercise

Select all columns from tables movie and director in such a way that a movie is shown together with its director. Select only those movies which were made after 2000.

### Stuck? Here's a hint!

Type:

SELECT
*
FROM movie
JOIN director
ON director_id = director.id
WHERE movie.production_year > 2000;