Correct query given problem


#1

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