How many posts were created in 2017?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT Top 10
T.TagName as Top_10_Tags,
Count(*) as Tag_Count
FROM PostTags PTS
JOIN Posts P on P.Id = PTS.PostId
JOIN Tags T on T.Id = PTS.TagId
WHERE year(P.CreationDate) = '2020'
GROUP BY T.TagName
ORDER BY Count(*) DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results