instruction: Win8 thread volume with accepted answers by month.
response: SELECT COUNT(*) AS AnsweredVolume, TIME_TO_STR(P.CreationDate, '%Y') AS "year", TIME_TO_STR(P.CreationDate, '%m') AS Month FROM Posts AS P WHERE (Tags LIKE '%<windows-8>%' OR Tags LIKE '%<metro-ui>%' OR Tags LIKE '%<metro-style-app>%' OR Tags LIKE '%<winrt>%' OR Tags LIKE '%<c++-cx>%') AND PostTypeId = 1 AND CommunityOwnedDate IS NULL AND ClosedDate IS NULL AND AcceptedAnswerId > 0 GROUP BY TIME_TO_STR(P.CreationDate, '%YEAR'), TIME_TO_STR(P.CreationDate, '%-mONT%-H') ORDER BY 'year', Month