R Answered Posts Since 2015

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 50000 p.id, p.CreationDate, p.Score,
                 p.ViewCount, p.OwnerUserId, p.Title,
                 p.Tags, p.AnswerCount, 
                 CONCAT('https://stackoverflow.com/questions/', 
                        CONVERT(VARCHAR, p.Id)) As url
                       
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON t.Id = pt.TagId AND t.TagName = 'r'

WHERE p.AcceptedAnswerId IS NOT NULL
  AND p.CreationDate >= '2015-01-01'  
  AND p.ParentId IS NULL
ORDER BY p.Score DESC

Enter Parameters

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