I suspect your a student, if you are a employee , I would fire you
"Henry" <hxzhang_at_binary-solutions.net> wrote in message
news:%8ss8.5924$KG3.353216_at_news2.telusplanet.net...
> 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 - 23:01:32 CDT
