Q&A for dedicated home brewers and serious enthusiasts
SELECT COUNT(*) as Volume, SUM(ViewCount) as PageViews, COUNT(DISTINCT OwnerUserId) as UniqueOPs, DATEPART(year, P.CreationDate) as [Year], DATEPART(month, P.CreationDate) as Month FROM [Posts] as P WHERE (Tags like '%<activedirectorymembership>%' or Tags like '%<custom-server-controls>%' or Tags like '%<dynamicdata>%' or Tags like '%<dynamic-data>%' or Tags like '%<spring-mvc>%' or Tags like '%<mvcscaffolding>%' or Tags like '%<temporary-asp.net-files>%' or Tags like '%<asp.net%') and PostTypeId = 1 and CommunityOwnedDate is null and ClosedDate is null GROUP by DATEPART(YEAR, P.CreationDate), DATEPART(MONTH, P.CreationDate) ORDER by [Year], Month