Before we start, let's explain the data sets we're going to work on.
Remember the car table from earlier? We're going to use it now together with another table called person. We'll show you all the examples in this part based on these two tables.
We'll have cars (table car) and their owners (table person). We know the owner of the car because we have the column owner_id in the car table which contains an ID from the person table. Easy, right?
Take a look at the columns the tables contain:
person (id, name, age);
car (id, brand, model, price, owner_id);
In case you're already fed up with the cars, we've created a new set of data for all the exercises in this part.
We're going to work with movies and their directors.
Open the Database tab on the right and study the tables. Think about the following question: How do we know who directed a specific movie?
When you're done, simply click and we'll tell you the answer.
