title: SQL - Count of each category of film ED CHASE has been in
body: <p>I'm trying to return a table with <code>category.name</code> and the count of the number of films that ED CHASE was in which were in that category. The query should return every category even if ED CHASE hasn't been in a film in that category.</p>
  
  <p>This is the schema:
  <a href="https://i.stack.imgur.com/Juvhm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Juvhm.png" alt=""></a></p>
  
  <p>All I have so far is a way to select all category names.  I haven't been able to tie this into ED CHASE in any way though.</p>
  
  <pre><code>SELECT category.name
  FROM film_category
  INNER JOIN category ON film_category.category_id = category.category_id,
  </code></pre>
  
  <p>I've tried to join these results with <code>film_actor</code>, but I keep getting syntax errors when trying to do that.</p>
  
  <pre><code>SELECT category.name
  FROM film_category
  INNER JOIN category ON film_category.category_id = category.category_id,
  INNER JOIN film_actor ON film_category.film_id = film_actor.film_id
  </code></pre>