Good answers to bad questions

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)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

-- 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##

Enter Parameters

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