0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

declare @tag nvarchar(35) = ##tag:string##



select 
year(ClosedDate) as [Year],
count(*) as [Questions]
from 
posts
left join PostHistory as PH on PH.PostId = posts.Id
where 
charindex(@tag,Tags) > 0
and PostTypeId = 1
and ClosedDate is not null 
and Comment = '101'
group by
year(ClosedDate)

fork query

edited oct 17

created oct 17 0Valt