Well, i dont have Oracle on my machine right now to try it out. But i dont think that will work b/c to use nvl is to assume that a record is returned.
what i want is if no emp is in Job 3, then return a record with:
count - dept - job
0 - A - 3
but, no record is returned with job 3