SELECT DATEPART(year, p.creationdate) as year, count(DA...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

--SELECT * from posts 
--where tags is not null 
--and tags!='' 
--and creationdate >= '2023-12-01' AND creationdate <= '2024-01-01' 

SELECT  DATEPART(year, p.creationdate) as year, 
        count(DATEPART(year, p.creationdate)),
        t.tagname
from posttags pt 
    join tags t on t.id=pt.tagId
    join posts p on p.id=pt.postId
where t.tagname LIKE '%python%'   
      OR t.tagname LIKE '%java%'
      OR t.tagname LIKE '%c++%'
group by DATEPART(year, p.creationdate), t.tagname
order by year

Enter Parameters

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