如何将两个GROUP BY的结果按条件合并

[qq_37400227]

如图
两个按jzks group by的查询结果

select jzks,count(*)as yyrs from tab group by jzks
select jzks,count(*)as ryrs from tab group by jzks
如何将结果继续按groupby合并
达到如下的效果
jzks yyrs ryrs
全科 15 5
院长 1 0
姓付 1 0

[二月十六]

SELECT t1.*,
       ISNULL(t2.ryrs,0)
FROM
(SELECT jzks, COUNT(*) AS yyrs FROM tab GROUP BY jzks) t1
    LEFT JOIN
    (SELECT jzks, COUNT(*) AS ryrs FROM tab GROUP BY jzks) t2
        ON t1.jzks = t2.jzks;