Easy
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?
Author: Vincent CotroStatus: PublishedQuestion passed 1130 times
Edit
1
Community EvaluationsNo one has reviewed this question yet, be the first!
Similar QuestionsMore questions about SQL