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

SELECT TOP(50000) Id, CreationDate, Score, ViewCount, AnswerCount, CommentCount, FavoriteCount, Title, Body, Tags

FROM Posts

WHERE CreationDate BETWEEN CONVERT(datetime, '2012-01-01') AND CONVERT(datetime, '2023-02-01')

AND Title IS NOT NULL

AND Body IS NOT NULL

AND Score > 5

AND ViewCount > 10

AND AnswerCount > 1

AND CommentCount > 1

AND FavoriteCount IS NOT NULL

AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 5

ORDER BY CreationDate

fork query

edited oct 2 23

created oct 2 23 anonymous