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)