0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
  TOP(500) p.CommentCount,
          p.Id as [Post Link],
          p.ViewCount, Tags
FROM Posts p
WHERE 
    p.Score >= 0 AND
    p.Viewcount > 200 AND
    p.CommentCount < 5 AND
    p.CreationDate > '2023-01-14'
ORDER BY
    p.Viewcount DESC

fork query

edited jan 16 23

created jan 16 23 James.Risner