学步园

select case when count(mgr)!=0 then count(mgr) else 0 end cnt,mgr from emp group by mgr,JOB;
SELECT * FROM USER_COL_COMMENTS ;