Write a script that creates and calls a stored function named films_per_category that finds the number of films for a given category. The function should accept a category name (varchar). o Write a...

Write a script that creates and calls a stored function named films_per_category that finds the number of films for a given category. The function should accept a category name (varchar). o Write a query which selects all the categories Show the Category name along with the number of films. Use the function you wrote in this query.