0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT 
  d.dt,
  Count(*) as number
FROM (
    select FORMAT(CreationDate,'MM yyyy') as dt
    FROM 
        Posts p
    JOIN PostTags t on p.Id = t.PostId
    WHERE 
        t.TagId = 121443

      --  AND p.PostTypeId = 1 -- Questions
    ) d
GROUP BY d.dt

fork query

edited sep 30 23 anonymous

created feb 8 16 jon.doe21521