0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select dateadd(month, datediff(month, 0, q.CreationDate), 0) m, TagName, count(*)
from PostTags pt
join Posts q on q.Id=pt.PostId
join Tags t on t.Id=pt.TagId
where TagName in ('arch-linux', 'fedora', 'gentoo', 'kali-linux', 'linux-mint', 'opensuse', 'rhel')
and q.CreationDate > '20100726'
and q.CreationDate < dateadd(month, datediff(month, 0, getdate()), 0)
group by dateadd(month, datediff(month, 0, q.CreationDate), 0), TagName
order by dateadd(month, datediff(month, 0, q.CreationDate), 0)

fork query

edited sep 5 anonymous

created jul 26 17 Michael.McGrath