Simple solution sql

interview-questions
Tags: #<Tag:0x00007f1832e38ba8>

#1

select concat(d.director_first_name,d.director_last_name) as ‘director_name’,m.movie_title

from directors as d,movies_cast as mc , movies as m,movies_directors as md where

mc.movie_id = m.movie_id and m.movie_id = md.movie_id and md.director_id = d.director_id and mc.role=‘SeanMaguire’