1 USE imdb; 2 DELIMITER && 3 CREATE PROCEDURE all_crew(IN movie VARCHAR (400)) 4 BEGIN SELECT primary_title, type, name, category 6 FROM titles 7 JOIN crew ON crew.title_id = titles.title_id 8 JOIN...

Please type the missing line of code to replace the  "-- INSERT MISSING CODE HERE" with the correct end of the statement.

Extracted text: 1 USE imdb; 2 DELIMITER && 3 CREATE PROCEDURE all_crew(IN movie VARCHAR (400)) 4 BEGIN SELECT primary_title, type, name, category 6 FROM titles 7 JOIN crew ON crew.title_id = titles.title_id 8 JOIN people ON people.person_id = crew.person_id %3D INSERT MISSING CODE HERE 10 END && 11 DELIMITER ;