0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

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

fork query

edited apr 25 19 anonymous

created jan 25 16 jon.doe15645