ViewCount for Tags Created in 2019 and Active in 2019

0

Please login or register to vote for this query.

(click on this box to dismiss)

Aviation

Q&A for aircraft pilots, mechanics, and enthusiasts

SELECT TagName, SUM(ViewCount)
  FROM Posts AS p 
                INNER JOIN PostTags AS pt ON pt.PostId=p.id
                INNER JOIN Tags AS t ON t.id=pt.TagId
                WHERE (PostTypeId = 1 AND YEAR(CreationDate) = 2019 AND YEAR(LastActivityDate) = 2019)
 GROUP BY TagName
 ORDER BY 2 DESC;

Enter Parameters

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