Perfect answer!


#1

There You go!

select concat(directors.director_first_name, directors.director_last_name)
as director_name, movie_title
from movies, movies_directors, movies_cast, directors
where
movies_directors.movie_id = movies.movie_id
and movies.movie_id = movies_cast.movie_id
and directors.director_id = movies_directors.director_id
and movies_cast.role = “SeanMaguire”;


#2

Solution
select concat(directors.director_first_name, directors.director_last_name)
as ‘director_name’, movie_title
from movies
join movies_directors on movies_directors.movie_id = movies.movie_id
join directors on directors.director_id = movies_directors.director_id
join movies_cast on movies.movie_id = movies_cast.movie_id and movies_cast.role = ‘SeanMaguire’


#3

why is the movies_cast.role = ‘SeanMaguire’ an AND statement instead of a WHERE statement?


#4
select concat(director_first_name, director_last_name) as 'director_name', movie_title
from directors, movies, movies_cast, movies_directors
where movies.movie_id = movies_cast.movie_id and movies.movie_id = movies_directors.movie_id
and directors.director_id = movies_directors.director_id and movies_cast.role = 'SeanMaguire'

just a small difference!