What's wrong in this query?


#1

SELECT (Directors.Director_First_Name,Directors.Director_Last_Name) AS Director_Name,
Movies.Movie_Title
FROM Directors
INNER JOIN Movies_Director
ON Directors.Director_ID = Movies_Director.Director_ID
INNER JOIN Movies
ON Movies.Movie_ID = Movies_Director.Movie_ID
INNER JOIN Movies_Cast
ON MoviesCast.Movie_ID = Movies.Movie_ID
AND MoviesCast.Role = ‘SeanMaguire’


#2

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