title: Combining RIGHT JOIN with COUNT
body: <p>I'm trying to get a list of the number of entries in the <code>changes_cc</code> table by each user. Not all users have made entries into it, however for some reason it's returning "1" for each user that has 0 entries. I'm assuming that it's because it's counting the entries in the <code>JOIN</code>ed table. How can I make it so that it is "0" instead?</p>
  
  <pre><code>SELECT COUNT(*) as num, users.id, realname, username
              FROM changes_cc
              RIGHT JOIN users
                  ON changes_cc.user_id = users.id
              GROUP BY users.id
  </code></pre>