SELECT TOP 20 p.Id as [Post Link], COUNT(v.PostId)/p.Answ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

SELECT
  TOP 20
  p.Id as [Post Link],
  COUNT(v.PostId)/p.AnswerCount as RecentUpvotes,
  p.Score,
  p.ViewCount,
  p.AnswerCount,
  MAX(a.Score) As HighestAnswerScore
FROM Tags t
JOIN PostTags pt ON pt.TagId = t.Id 
JOIN Posts as p ON p.Id = pt.PostId
JOIN Votes v ON v.PostId = p.Id
JOIN Posts a -- Answers
  ON a.ParentId = p.Id
  AND a.PostTypeId = 2 -- Only Answers

WHERE TagName = 'tensorflow.js' -- Remove tag to get overview over all questions
  AND v.VoteTypeId = 2 -- Only Upvotes
  AND v.CreationDate > '2019-04-01'
GROUP BY p.Id, p.Score, p.ViewCount, p.AnswerCount
HAVING MAX(a.Score) < 10
ORDER BY RecentUpvotes DESC

Enter Parameters

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