I was jus wondering how to write an sql query for retrieving the following
data:

Table columns... employee name, ID, employee grade, type of job pursuing.
(The "type of job" field can take one out of 3 predefined values and is non

null)- primary key of the table is employee ID

Question: I want to know the no. of each type of job pursued by employees of
each grade

Output required... employee grade, No. of type 1 jobs pursued, no. of type 2

jobs pursued, no. of type 3 jobs pursued.

regds
Raj