DELIMITER $$

DROP PROCEDURE IF EXISTS `get_book_count`;
CREATE PROCEDURE get_book_count(f_name VARCHAR(50), l_name VARCHAR(50))
BEGIN
	DECLARE Cnt int;

   SELECT Cnt = COUNT(*) FROM `books` AS `b`
	WHERE `b`.`author_id` = (
		SELECT `author_id` FROM `authors` AS `a`
		WHERE `a`.`first_name` = f_name AND `a`.`last_name` = l_name
		LIMIT 1);

	SELECT CONCAT(f_name, " ", l_name, " has written ", Cnt, " books.");

END $$

CALL get_book_count("Amanda", "Rice");