INSERT INTO T1 VALUES ('MOO1','FT')
INSERT INTO T1 VALUES ('MOO1','FT')
INSERT INTO T1 VALUES ('MOO2','PY')
INSERT INTO T1 VALUES ('MOO2','PY')
INSERT INTO T1 VALUES ('MOO2','PY')
INSERT INTO T1 VALUES ('MOO2','PY')
select count(1),GPID from T1
WHERE MID IN('MOO1')
GROUP BY ROLLUP(GPID)
UNION
select count(1),GPID from T1
where MID IN('MOO2')
GROUP BY ROLLUP(GPID)