How many posts were created in 2017?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Electrical Engineering

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

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 meta site
loading Hold tight while we fetch your results