Questions with [tag] per [period] with score more than [score]

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 @tag nvarchar(35) = ##tag:string?google-apps-script##
declare @minScore int = ##score:int?0##

select
  Id as [Post Link], 
  Tags,
  AnswerCount as Answers,
  Score
from
  Posts
where
  PostTypeId = 1
  and
  CreationDate >= dateadd(##metric?day##, ##offset?-7##, getdate())
  and
  ClosedDate is null
  and
  Score > @minScore
  and
  charindex(@tag,Tags) > 0
order by
  Score
desc

Enter Parameters

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