0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for computer graphics researchers and programmers

SELECT COUNT(0) AS Question, SUM(q.FavoriteCount) AS 'Watchers', t.TagName FROM Posts q
INNER JOIN PostTags pt ON q.Id = pt.PostId
INNER JOIN Tags t ON t.Id = pt.TagId
WHERE q.PostTypeId IN (1, 2)
AND q.CreationDate >= '2017-1-1'
AND q.CreationDate < '2019-1-1'
AND t.TagName In ('uwp', 'wpf', 'winforms', 'electron', 'swing', 'javafx', 'qt', 'javascript', 'html', 'css', 'angularjs', 'reactjs', 'vue.js', '.net', '.net-core')
GROUP BY t.TagName;

fork query

edited aug 21 19 codemeow

created jun 30 19 jon.doe31683