title: SQL: Count rows which are not present in table
body: <p>I got two tables called: EmployeeTable &amp; TaskAssignmentTable.
  They look like this :
  <img src="https://i.stack.imgur.com/U9ARi.png" alt="tables formation">
  <br/>
  TaskAssignmentTable shows tasks assigned to employees. In order to assign new tasks to employees i want to have count of tasks assigned to different people and then assign task to people who have least tasks assigned.<br/>
  Problem: using normal count() on TaskAssignmentTable results in this table:
  <img src="https://i.stack.imgur.com/X8XWP.png" alt="enter image description here">
  <br/>But what i want is some sort of join between tables which shows count of rows which are present in first table and absent in 2nd table with count equal to 0 like this one:</p>
  
  <p><img src="https://i.stack.imgur.com/IGzP0.png" alt="enter image description here"></p>
  
  <p>So what would be the SQL query to join tables and do such thing? (Optional: Since I'm using C# Linq-2-SQL i would be grateful if someone can write LINQ syntax for this).</p>