13

select PT."Name", count(*)
from "AgentEmails" as AE
join "Agents" A on ae."AgentId" = A."AgentId"
join "AgentProductTypes" APT on A."AgentId" = APT."AgentId"
join "ProductTypes" PT on APT."ProductTypeId" = PT."EnumId"
where APT."ProductTypeId" in (1, 4, 25)
group by PT."Name"