0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

DECLARE @initial_date DATE
DECLARE @final_date DATE
SET @initial_date = '2020-01-01'
SET @final_date = DATEADD(m , 12 , @initial_date)

SELECT TOP 500000 Title, Body, CreationDate, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount
FROM Posts 
WHERE PostTypeId = 1
AND CreationDate between @initial_date and @final_date
AND ViewCount > 10 
AND FavoriteCount > 0
AND Score > 5 
AND AnswerCount > 0 
AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) > 0
AND CommentCount > 5

fork query

edited sep 27 22

created sep 27 22 anonymous