Post Count by Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

-- Post Count by Tag
-- Enter Query Description

SELECT COUNT(*) as suma , T.TagName 
FROM POSTS P
INNER JOIN PostTags PT on (P.ID=PT.PostID)
INNER JOIN Tags T on (PT.TagID=T.ID)
WHERE T.TagName = 'apache-zeppelin' 
AND P.CreationDate  BETWEEN  CONVERT(datetime,'2018-01-01') AND CONVERT(datetime,'2019-01-01')
GROUP BY T.TagName
ORDER BY Count(*) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results