0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT CAST(CONVERT(VARCHAR(7), CreationDate, 120) + '-01' AS datetime),
       COUNT(*)
FROM Posts
WHERE Tags LIKE '%<perl6>%'
GROUP BY CONVERT(VARCHAR(7), CreationDate, 120)
ORDER BY CONVERT(VARCHAR(7), CreationDate, 120)

fork query

created jan 25 16 jon.doe15645