title: SQL: Output 0 when a count() has no rows
body: <p>I have the following query</p>
  
  <pre><code>Select
      count(project.id) as '# Projects',
      c2.name as ' Country name'
  from
      project,
      country c2,
      project_country
  where
      project_country.project_id = project.id and
      project_country.country_id= c2.id
  group by
      c2.name;
  </code></pre>
  
  <p>Which returns the number of projects related to a specific country only if the <code>count()&gt;0</code>.</p>
  
  <p>For the countries that don't have any project associated with I would want to get the <strong>0</strong> value in the <strong>#Projects</strong> column. Is there any way I can achieve this in <strong>mysql</strong>?</p>