SELECT 'JP 3-1', BBKCDT, COUNT(*) FROM JEMSHDP31.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT
UNION
SELECT 'JP 3-2', BBKCDT, COUNT(*) FROM JEMSHDP32.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT
UNION
SELECT 'JP 4-1', BBKCDT, COUNT(*) FROM JEMSHDP41.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT
UNION
SELECT 'JP 4-2', BBKCDT, COUNT(*) FROM JEMSHDP42.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT
UNION
SELECT 'JP 7-1', BBKCDT, COUNT(*) FROM JEMSHDP71.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT
UNION
SELECT 'JP 7-2', BBKCDT, COUNT(*) FROM JEMSHDP72.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT
UNION
SELECT 'JP 8-1', BBKCDT, COUNT(*) FROM JEMSHDP81.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT
UNION
SELECT 'JP 8-2', BBKCDT, COUNT(*) FROM JEMSHDP82.CCECOCP WHERE BBBHCD='DM' GROUP BY BBKCDT