SELECT
    c.Affiliation 'Association',
    COUNT(p.IdClientPolicy) 'Active Policies',
    SUM(p.BilledPremium) 'Total Premium'
FROM Client c
INNER JOIN ClientPolicy p ON p.IdClient = c.IdClient AND p.IdStatus = 12 AND p.IdInsurance IN (1945, 1032)
GROUP BY c.Affiliation