(Adapted from http://sqlserverpedia.com/wiki/StackOverflow_Old_Unanswered_Questions_Query)
Want to answer StackOverflow questions to boost your reputation, but you can't find any old ones that are easy enough for you to answer? This query will hunt them out. You can change these things in the WHERE clause:<
* p.Tags LIKE '%sql%' - change the sql keyword to one you're interested in.
* p.AnswerCount <= 1 - only one (or zero) person made a suggested answer, but since p.AcceptedAnswerId IS NULL, we know the answer wasn't accepted.
* p.CommentCount <= 1 - only one (or zero) comments were made, which means it didn't catch anybody's interest.
We sort by p.LastActivityDate because we want to find the questions that fell off the radar. The older they are, the easier they are to swoop in and answer. Plus, keep in mind that the StackOverflow database is only exported periodically - newer questions are more likely to have already been answered by someone since the database export was made.
Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation