Identification questions with a minimum question score and answer score

1

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT question.Id [Post Link], question.Score AS 'Question Score', question.ClosedDate
FROM Posts question
INNER JOIN PostTags pt ON pt.PostId = question.Id
INNER JOIN Tags t on pt.TagId = t.Id
INNER JOIN Posts answer ON question.Id = answer.ParentId
WHERE t.TagName LIKE '%identify-this-song%'
AND question.Score > ##MinQuestionScore##
AND answer.Score > ##MinAnswerScore##
ORDER BY question.Score DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results