0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for science fiction and fantasy enthusiasts

SELECT Tags.TagName, 
       Count(Tags.TagName) AS TagCount 
FROM   Posts 
       JOIN PostTags 
         ON Posts.Id = PostTags.PostID
       JOIN Tags 
         ON PostTags.TagID = Tags.ID
WHERE  Posts.Tags LIKE '%<python>%' AND Posts.CreationDate >= DATEADD(m, -25, GETDATE())
GROUP  BY Tags.TagName 
ORDER  BY TagCount DESC

fork query

edited jul 16 Thomas.Hillman

created dec 15 21 anonymous