With tags_python as (SELECT p.id, p.creationdate, p.tags...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

With tags_python as 
(SELECT  p.id, p.creationdate, p.tags
      from posts p
where tags LIKE '%python%' )

SELECT  count(p.tags) OVER (PARTITION BY DATEPART(year, p.creationdate)),
       DATEPART(year, p.creationdate)
      from tags_python p
where DATEPART(year, p.creationdate)>=2020 and DATEPART(year, p.creationdate)<=2023

Enter Parameters

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