0

Please login or register to vote for this query.

(click on this box to dismiss)

In this query I try to know wich language is most popular for machine learning in Stack Overflow by searching the amount of question of some mayor languages wich already have the tag "machine-learning"

Q&A for amateur radio enthusiasts

SELECT year(p.CreationDate) +
       (month(p.CreationDate)-1) /12. yr_month, 
       TagName,
       count(*) questions
FROM Posts p, PostTags pt, Tags t
WHERE 1=1
AND p.id = pt.PostId
AND t.id = pt.TagId
AND t.tagName in ('ethereum', 'solidity')
AND year(p.CreationDate) >= year(getdate()) - 3 
GROUP BY year(p.CreationDate), month(p.CreationDate), tagname
order by year(p.CreationDate), month(p.CreationDate)

fork query

edited nov 13 18 anonymous

created dec 4 17 Afesant