If I had a table like this:
jobId, jobName, Priority
Whereby Priority can be an integer between 1 to 5.
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.
Priority1 should count the amount of rows where priority field has the value of 1.
Priority2 should count the amount of rows where priority field has the value of 2.
Priority3 should count the amount of rows where priority field has the value of 3.
etc
How would I do that in a quick and performant manner?