What is error in following query


#1

select concat(directors.director_first_name, directors.director_last_name)
as director_name, movie_title from directors
join movies_directors on directors.director_id=movies_directors.director_id
join movies on movies_directors.movie_id=movies.movie_id
join movies_cast on movies_cast.movie_id=movies.movie_id
join actors on actors.actor_id=movies_cast.actor_id
where actors.actor_first_name=‘Sean’ and actors.actor_last_name=‘Maguire’


#2

SeanMaguire is not an actor name but role (a column in movies_cast table)


#3
  1. SELECT concat(D.director_first_name,D.DIRECTOR_LAST_NAME) AS director_name, M.MOVIE_TITLE AS movie_title
  2. FROM movies M
  3. INNER JOIN movies_directors MD ON MD.movie_id=M.movie_id
  4. INNER JOIN movies_cast MC ON MC.movie_id =M.movie_id
  5. INNER JOIN directors D ON D.director_id =MD.director_id
  6. WHERE MC.role LIKE ‘SeanMaguire’;