Whats wrong with query?


#1

select d.director_first_name+d.director_last_name as director_name, m.movie_title from directors d, movies m where d.director_id =( select director_id from movies_directors where movie_id =(select movie_id from movies_cast where role =‘SeanMaguire’)) and m.movie_id = (select movie_id from movies_cast where role =‘SeanMaguire’)