Questions 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 DISTINCT(Tags), COUNT
  FROM Posts AS p 
                JOIN PostTags AS pt ON pt.PostId=p.id
                JOIN Tags AS t ON t.id=pt.TagId
 WHERE PostTypeId = 1 AND YEAR(CreationDate) = 2019
 ORDER BY COUNT DESC;

Enter Parameters

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