SELECT 
  cc.ResidencyZip AS ZIP, 
  COUNT(e.EthnicityDesc) AS 'Record Count',
  SUM(CASE WHEN  e.EthnicityDesc = 'White' THEN 1 ELSE 0 END) AS BENCOUNT1,
  SUM(CASE WHEN  e.EthnicityDesc = 'Black' THEN 1 ELSE 0 END) AS BENCOUNT2,
  SUM(CASE WHEN  e.EthnicityDesc = 'Asian' THEN 1 ELSE 0 END) AS BENCOUNT3,
  CONVERT(DECIMAL(18,2),1.0 * COUNT(e.EthnicityDesc)/COUNT(cc.ChildPartyID) * 100) AS 'Percentage' 
FROM CaseChild cc 
  INNER JOIN Party p 
    ON cc.childPartyID = p.partyID 
  INNER JOIN Ethnicity e 
    ON p.EthnicityID = e.EthnicityID
WHERE (cc.programID = 6)
GROUP BY	 cc.ResidencyZip
ORDER BY	 cc.ResidencyZip 

SELECT cc.ResidencyZip as ZIP, e.EthnicityDesc,
    Count(*) as record_count,
    Convert(decimal(18,2),100.0 * COUNT(*) / COUNT(*) OVER (PARTITION BY ResidencyZip)) AS ethnicity_percent
  FROM CaseChild cc
    JOIN Party p on cc.childPartyID = p.partyID
    JOIN Ethnicity e on p.EthnicityID = e.EthnicityID
  WHERE (cc.programID = 6)
  GROUP BY cc.ResidencyZip, e.ethnicityDesc
  ORDER BY cc.ResidencyZip