title: Conditional Count on a field
body: <p>If I had a table like this:</p>
  <pre><code>jobId, jobName, Priority
  </code></pre>
  <p>Whereby Priority can be an integer between 1 to 5.</p>
  <p>Since I would need this query for generating a chart on report, I would need to display the jobid, jobname and 5 fields called Priority1, Priority2, Priority3, Priority4. Priority5.</p>
  <p>Priority1 should count the amount of rows where priority field has the value of 1.</p>
  <p>Priority2 should count the amount of rows where priority field has the value of 2.</p>
  <p>Priority3 should count the amount of rows where priority field has the value of 3.</p>
  <p>etc</p>
  <p>How would I do that in a quick and performant manner?</p>