0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

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

fork query

edited aug 3 20

created jul 11 20 0Valt