the result was in format
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;