Here is the exact CTE I am using

WITH ContactCTE AS(

SELECT Contacts.ContactId

, COUNT(DISTINCT(Plans.PlanId)) AS PlanCount

, MAX(Plans.CreatedOn) As LastDatePlanAdded

, CompanyNames.cnName AS CompanyName

...