SELECT TOP 100 PERCENT dbo.tblESSurveyW1Demo.CQ30, SUM(dbo.tblESSurveyW1Weight.weight_bb) AS WeightedCount,
COUNT(dbo.tblESSurveyW1Weight.RESPID) AS UnWeighted
FROM dbo.tblESSurveyW1Weight INNER JOIN
dbo.tblESSurveyW1Demo ON dbo.tblESSurveyW1Weight.RESPID = dbo.tblESSurveyW1Demo.RESPID
GROUP BY dbo.tblESSurveyW1Demo.CQ30
ORDER BY dbo.tblESSurveyW1Demo.CQ30