0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

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;

fork query

edited aug 4

created aug 4 Rebecca J. Stones