I was jus wondering how to write an sql query for retrieving the following
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
Output required... employee grade, No. of type 1 jobs pursued, no. of type 2
jobs pursued, no. of type 3 jobs pursued.