Q&A about the site for expert genealogists and people interested in genealogy or family history
SELECT COUNT(*) as AnsweredVolume, DATEPART(year, P.CreationDate) as [Year], DATEPART(month, P.CreationDate) as Month FROM [Posts] as P WHERE ([Tags] like '%<android%' ) and PostTypeId = 1 and CommunityOwnedDate is null and ClosedDate is null and AcceptedAnswerId > 0 GROUP by DATEPART(YEAR, P.CreationDate), DATEPART(MONTH, P.CreationDate) ORDER by [Year], Month