title: Count removes all but one value, instead of showing one of each value, and distinct replaces names with '0'
body: <p>I want to show how many films each actor has played (sakila db on MySQL)</p>
  <pre><code>select distinct (a.first_name + ' ' + a.last_name as &quot;Actor Full Name&quot;),
         count(distinct(fa.film_id))
  from actor a join film_actor fa
  on a.actor_id = fa.actor_id;
  </code></pre>