Valid questions for "It almost works"

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges

Q&A for programming puzzle enthusiasts and code golfers

SELECT Q.Id AS [Post Link], Q.Tags, Q.Score, Q.AnswerCount
  FROM Posts Q
  -- Post is question
  WHERE Q.PostTypeId = 1
  -- +10 net score
  AND Q.Score >= 10
  -- Open
  AND Q.ClosedDate IS NULL
  -- Not language-specific
  -- ???
  -- Posted before 8 Jul 2021
  AND Q.CreationDate < Convert(datetime, '20210708')
  -- Not [tag:tips]
  AND Q.Tags NOT LIKE '%tips%'
  -- [tag:code-golf]
  AND Q.Tags LIKE '%code-golf%'
  -- Have at least 3 existing answers
  AND Q.AnswerCount >= 3
  -- Some more filters
  AND Q.Tags NOT LIKE '%kolmogorov-complexity%'
  AND Q.Tags NOT LIKE '%cops-and-robbers%'
  
  ORDER BY Q.Score DESC, Q.AnswerCount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results