SELECT 'JP 3-1', COUNT(*) FROM JEMSHDP31.CCACIDP LEFT JOIN JEMSHDP31.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501
UNION
SELECT 'JP 3-2', COUNT(*) FROM JEMSHDP32.CCACIDP LEFT JOIN JEMSHDP32.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501
UNION
SELECT 'JP 4-1', COUNT(*) FROM JEMSHDP41.CCACIDP LEFT JOIN JEMSHDP41.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501
UNION
SELECT 'JP 4-2', COUNT(*) FROM JEMSHDP42.CCACIDP LEFT JOIN JEMSHDP42.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501
UNION
SELECT 'JP 7-1', COUNT(*) FROM JEMSHDP71.CCACIDP LEFT JOIN JEMSHDP71.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501
UNION
SELECT 'JP 7-2', COUNT(*) FROM JEMSHDP72.CCACIDP LEFT JOIN JEMSHDP72.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501
UNION
SELECT 'JP 8-1', COUNT(*) FROM JEMSHDP81.CCACIDP LEFT JOIN JEMSHDP81.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501
UNION
SELECT 'JP 8-2', COUNT(*) FROM JEMSHDP82.CCACIDP LEFT JOIN JEMSHDP82.CCECOCP ON A2W5CF=BBCRCD WHERE A2Z9SW='Y' AND BBKNDT>=1110501