with tagsnamepython as (select t.tagname as tagname, t.i...

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' 

      --OR t.tagname LIKE '%java%'
      --OR t.tagname LIKE '%c++%'
      --OR t.tagname LIKE '%javascript%'
      --OR t.tagname LIKE '%c#%'
      --OR t.tagname LIKE '%php%'
      --OR t.tagname LIKE '%sql%'
      --OR t.tagname LIKE 'r'
      --OR t.tagname LIKE 'c'
with tagsnamepython as
(select t.tagname as tagname,
         t.id as id 
from tags t
where t.tagname LIKE '%python%'   

)

SELECT  DATEPART(year, p.creationdate) as year, 
        count(DATEPART(year, p.creationdate)),
        t.tagname 
from posttags pt 
    join tagsnamepython t on t.id=pt.tagId
    join posts p on p.id=pt.postId

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