no_actors.sql

USE sakila;
DROP PROCEDURE IF EXISTS film_actors;
DELIMITER |
CREATE PROCEDURE film_actors(IN film_title VARCHAR(45), OUT no_actors INT)
BEGIN
	SELECT COUNT(a.actor_id) INTO no_actors
		FROM actor AS a
			INNER JOIN film_actor USING(actor_id)
			INNER JOIN film AS f USING(film_id)
		WHERE f.title = film_title;
END |
DELIMITER ;