0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

SELECT TOP 1000
    T.Id Id,
      T.TagName TagName,
      count(*) TagCount
    FROM Posts P
      INNER JOIN PostTags PT ON PT.PostId = P.Id
      INNER JOIN Tags T ON T.Id = PT.TagId
    WHERE
      P.PostTypeId = 1 -- only questions
      and  year(P.CreationDate) between 2015 and 2018
    GROUP BY
      T.Id,
      T.TagName
    ORDER BY
      TagCount DESC

view current version

edited jan 19 21

created jan 19 21 anonymous