title: SQL: count all tasks that belong to a user inside each project
body: <p>I need to get the number of tasks that belong to a user inside each project on the system. The tables are:</p>
  
  <p>Projects:
  ID, Name</p>
  
  <p>Tasks:
  ID, ProjectID, Assignee(the user)</p>
  
  <p>Right now I'm doing this query:</p>
  
  <pre><code>SELECT Projects.ID, Projects.Name, COUNT(*) 
  FROM Tasks JOIN Projects ON Tasks.ProjectID = Projects.ID 
  WHERE Assignee=1 GROUP BY Projects.ID;
  </code></pre>
  
  <p>Which only works partially. IT returns the number of tasks but only for the projects which have tasks assigned to the user. I'd like the query to return all projects in the system, even if no task has been assigned.</p>
  
  <p>How can I do this?</p>
  
  <p>Thanks!</p>