I got the correct director name and movie title. why not accepted


#1

the result was in format
GusVanSant,GoodWillHunting

why it was not accepted?
query was -

set @movie_id = (select movie_id from movies_cast where role = ‘SeanMaguire’);

set @director_id = (select director_id from movies_directors where movie_id = @movie_id);

select concat(director_first_name,director_last_name,’,’, movie_title) from directors cross join movies where director_id = @director_id and movie_id = @movie_id;


#2

Your query will not give correct result as the answer has separate column for movie title.Try to get it out from concat function.