Counting records based on Condition

SELECT PCPNO,IPA,[Provider Name], COUNT(DISTINCT MEMBNO) as “Number_Of_Members”
FROM PCP
GROUP BY PCPNO, IPA, [Provider Name]
HAVING COUNT(DISTINCT IPA) = 1
ORDER BY Number_Of_Members desc