0

Please login or register to vote for this query.

(click on this box to dismiss)

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))  
  from posttags pt 
  join tags t on t.id=pt.tagId
  join posts p on p.id=pt.postId
where t.tagname = 'python'
group by DATEPART(year, p.creationdate)

fork query

edited apr 20

created apr 20 anonymous