title: Show COUNT of each possible grade for an employee, showing zero when there are no grade entries
body: <p>I have only one table available. I want to show the grade and the count of the number of times an employee has that grade recorded, but it must show a 0 for the grade if there are no records for that employee. I know how to do this using left join when two tables are present, but I only have 1 table.</p>
  
  <p>How is this possible?</p>
  
  <p>For example:<br>
  TABLE</p>
  
  <pre><code>empID |  dept  |  grade
   1    |   11   |    a
   2    |   11   |    a
   3    |   11   |    b
   1    |   22   |    c
   2    |   22   |    f
   3    |   22   |    d
   1    |   33   |    a
   2    |   33   |    a
   3    |   33   |    a
  </code></pre>
  
  <p>If I run <code>SELECT grade, count(grade) from table where empID = 1 Group by grade;</code>, for example, it ends up printing out only grades the employee got and the count. Now I want to also print out the 0s for grades the employee did not have.</p>