0

Please login or register to vote for this query.

(click on this box to dismiss)

How common are good answerts to bad questions. Query in response to tweet from codinghorror: "great answers, terrible questions. Not uncommon..." (http://j.mp/gbggha)

Q&A for science fiction and fantasy enthusiasts

-- Good answers to bad questions
-- How common are good answerts to bad questions. 
-- Query in response to tweet from codinghorror: 
-- "great answers, terrible questions. Not uncommon..." 
-- (http://j.mp/gbggha)

SELECT count(*)
FROM Posts
JOIN 
(select Id, Score, ParentId
FROM Posts
WHERE Posts.PostTypeId = 2 -- answer
AND Posts.Score > ##GoodThreshold##) as Answers ON Posts.Id = Answers.ParentId
where PostTypeId = 1 --question
AND Posts.Score < ##BadThreshold##

fork query

created apr 14 11 anonymous