title: How To Count Null Values With This Query
body: <p>I'm messing around in my school's database and I am trying to count the <code>null</code> values in this query:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT Depart_ID, DepartName,
         COUNT(Name) AS employees, 
         SUM(Salary) AS 'Total salary'
  FROM Ch4Employee AS E
  INNER JOIN Ch4Department AS D 
     ON E.Depart_ID = D.ID
  GROUP BY Depart_ID, DepartName
  </code></pre>
  <p>Any tips?</p>