Bottom 1,000 python answers on Stack Overflow

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 1000
  answer.Score,
  answer.Id                                                                             [Post Link],
  (CASE WHEN answer.Id = question.AcceptedAnswerId
    THEN 'yes'
   ELSE 'no' END)                                                                    AS 'Accepted?',
  question.CreationDate                                                              AS 'Asked On',
  answer.CreationDate                                                                AS 'Answered On',
  Tags.TagName
FROM Posts answer
  INNER JOIN Posts question ON answer.ParentId = question.Id
  inner join PostTags on PostTags.PostId = question.Id
  inner join Tags on PostTags.TagId = Tags.Id
WHERE answer.PostTypeId = 2 and TagName like '%ython%'
ORDER BY answer.Score ASC;

Enter Parameters

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