select CONCAT_WS(d.director_first_name,’ ',d.director_last_name) as ‘director_name’,
b.movie_title
from movies_cast a
join movies b on
a.movie_id = b.movie_id join
movies_directors c on
b.movie_id = c.movie_id
join directors d on
c.director_id = d.director_id
where a.role = ‘SeanMaguire’