How many post do I have for each common DL framework tag and for each year?

0

Please login or register to vote for this query.

(click on this box to dismiss)

how long before I get tag badges?

Gardening and Landscaping

Q&A for gardeners and landscapers

SELECT
year(Posts.CreationDate) as Year,
Tags.TagName as Tag,
ROUND(100.0 * SUM(CASE WHEN AcceptedAnswerId>0 THEN 1 END) / Count(*), 1) as AnsweredPct
FROM Tags
    INNER JOIN PostTags ON PostTags.TagId = Tags.id
    INNER JOIN Posts ON Posts.Id = PostTags.PostId
WHERE
    (Tags.TagName='pytorch' OR Tags.TagName='tensorflow' OR Tags.TagName='keras' OR Tags.TagName='theano' OR Tags.TagName='caffe' OR Tags.TagName='mxnet' OR Tags.TagName='chainer' OR Tags.TagName='cntk')
GROUP BY TagName,year(Posts.CreationDate)
ORDER BY TagName,year(Posts.CreationDate)

Enter Parameters

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