SELECT CG.answer as cgroup, CP.answer as pclass, count(*) FROM CG, CP
WHERE CG.company = CP.company AND (cgroup='a' OR ..... cgroup='e') GROUP BY cgroup, pclass;