0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

SELECT TOP 50000 
    Title, Body, Tags, Id, Score, ViewCount, AnswerCount, CreationDate
FROM Posts
WHERE ViewCount IS NOT NULL 
  AND AnswerCount > 0 
  AND (LEN(Tags) - LEN(REPLACE(Tags, '<', ''))) >= 5
  AND FORMAT(CreationDate, 'yyyy') = '2021'

fork query

edited dec 6

created dec 6 anonymous