Write a SQL query to retrieve the titles of the movies and the names of their directors.

Question

Given the following 'movies' and 'directors' tables:
```
movies:
| movie_id | title   | director_id |
|----------|---------|-------------|
| 1        | Movie A | 1           |
| 2        | Movie B | 2           |
| 3        | Movie C | 1           |

directors:
| director_id | name        |
|-------------|-------------|
| 1           | Director 1  |
| 2           | Director 2  |
```
Which SQL query retrieves the titles of the movies and the names of their directors?

Accepted Answer

SELECT movies.title, directors.name FROM movies INNER JOIN directors ON movies.director_id = directors.director_id;

Answer

SELECT movies.title, directors.name FROM movies CROSS JOIN directors WHERE movies.director_id = directors.director_id;

Answer

SELECT movies.title, directors.name FROM movies LEFT JOIN directors ON movies.director_id = directors.director_id;

Answer

SELECT movies.title, directors.name FROM movies, directors WHERE movies.director_id = directors.director_id;

Question from the SQL - Fundamentals test

Write a SQL query to retrieve the titles of the movies and the names of their directors.