Trend of questions tagged with [tag]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @tagToSearch nvarchar(35) = ##tag:string##;
declare @offset int = ##offset?14##;

select
  datefromparts(
    datepart(year, CreationDate),
    datepart(month, CreationDate),
    1
  )
  as Created,
  count(Id) as [Questions Posted]
from
  Posts
where
  PostTypeId = 1
  and
  Tags like ('<%' + @tagToSearch + '%>')
  and
  DeletionDate is null
  and
  Score >= 0
  and
  CreationDate >= dateadd(##metric?day##, -@offset, getdate())
group by
  datefromparts(
    datepart(year, CreationDate),
    datepart(month, CreationDate),
    1
  )
order by
  Created
asc

Enter Parameters

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