Cacher is the code snippet organizer for pro developers

SELECT COUNT(NAME),PLNAME FROM SYSIBM.SYSDBRM
WHERE NAME IN ('moduleA','moduleB','moduleC')
GROUP BY PLNAME
HAVING COUNT(NAME) = 3
ORDER BY PLNAME