Average question viewcount per tag since 2019

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TagName, SUM(ViewCount) / count(*), count(*)
  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)
 GROUP BY TagName
 ORDER BY 2 DESC;

Enter Parameters

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