Q&A about the site for power users of web applications
DECLARE @StartDate DATE = '2022-10-01'; DECLARE @EndDate DATE = '2022-12-31'; SELECT id FROM posts WHERE PostTypeId = 1 AND score > 0 AND AnswerCount > 0 AND ( ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount > 10000 AND LastActivityDate BETWEEN DATEADD(MONTH, -6, GETDATE()) AND GETDATE() ) OR ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount > 15000 AND LastActivityDate BETWEEN DATEADD(MONTH, -12, GETDATE()) AND DATEADD(MONTH, -6, GETDATE()) ) OR ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount >= 25000 AND viewcount <= 50000 AND LastActivityDate < DATEADD(MONTH, -12, GETDATE()) ) OR ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount > 50000 ) )