We want to find out how many of each category of film ED CHASE has starred in.

So return a table with categ

-- We want to find out how many of each category of film ED CHASE has starred in.

-- So return a table with category_name and the count of the number_of_films that ED was in that category.

-- Your query should return every category even if ED has been in no films in that category

-- Order by the category name in ascending order.

film film_id title description release_year language_id original_language_i rental_duration rental_rate length replacement_cost category category_id name last_update language language_id name last_update film_category film_id category_id last_update actor actor_id first_name last_name last_update actor_id last_update film_id film_actor