Questions within the last month with more than x score.
Q&A for committed Christians, experts in Christianity and those interested in learning more
-- Recent High Scoring Questions
-- Questions within the last month with more than x score.
SET @MinimumScore = ##MinimumScore##
SELECT TOP 50 Score, CreationDate, PostTypeId, Id AS [Post Link], Title
WHERE Score >= @MinimumScore
AND CreationDate >= DATEADD(MONTH, -1, GETDATE())
-- AND PostTypeId =
ORDER BY Score DESC, CreationDate DESC;