view_films_category.sql

CREATE
     OR REPLACE
     DEFINER = airman@'localhost'
     SQL SECURITY DEFINER
     VIEW sakila.view_films_catagory AS
         SELECT c.name, COUNT(f.film_id) AS no_films
             FROM sakila.category c LEFT OUTER JOIN sakila.film_category USING(category_id)
                 LEFT OUTER JOIN sakila.film f USING(film_id)
             GROUP BY c.category_id;