how this can be done?

however, there could be no employ for a certain type at all.

My boss wants an query that list all types with its number of employees. and the sql result will be like:

type0  :   5 people
type1  :   1 people
type2  :   0 people

how can i accomplish this?
thanx a lot! Received on Mon Apr 08 2002 - 21:15:23 CDT