instruction: Voting makeup in regards to IDs.
response: SELECT YEAR(p.CreationDate) AS Yr, MONTH(p.CreationDate) AS Mnth, COUNT(DISTINCT p.Id) AS QuestionCount, COUNT(DISTINCT CASE WHEN p.Tags LIKE '%identify%' THEN p.Id ELSE NULL END) AS QuestionCountID, COUNT(v.Id) AS VoteCount, SUM(CASE WHEN p.Tags LIKE '%identify%' AND NOT v.Id IS NULL THEN 1 ELSE 0 END) AS VoteCountID FROM Posts AS p LEFT OUTER JOIN Votes AS v ON v.PostId = p.Id AND v.VoteTypeId IN (4, 6, 7, 10, 11, 12, 15, 16) WHERE p.PostTypeId = 1 GROUP BY YEAR(p.CreationDate), MONTH(p.CreationDate)