0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for 3D printing enthusiasts

select tagname, count(*) as c,convert(varchar(10),year(p.creationdate)) + '-'+ convert(varchar(10),month(p.creationdate)) as yearmonth

from posts p
join posttags pt on pt.postid=p.id
join tags t on pt.tagid=t.id

where year(p.creationdate) >= 2016 and tagname in (
'scikit-learn','pymc','pymc3',
'matplotlib','bokeh','seaborn','ggplot',
'numpy','scipy','statsmodels',
'gensim','spacy','nltk',
'tensorflow','theano','keras','pytorch','mxnet','cntk',
'opencv',
'beautifulsoup','scrapy','pandas'
)


group by tagname, convert(varchar(10),year(p.creationdate)) + '-'+ convert(varchar(10),month(p.creationdate))
order by tagname, convert(varchar(10),year(p.creationdate)) + '-'+ convert(varchar(10),month(p.creationdate))

fork query

edited oct 20 17

created oct 20 17 anonymous