0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

SELECT TOP(##num##)
  COUNT(a.Id), a.PostId AS [Post Link], b.Score
FROM Comments a inner join Posts b ON b.Id = a.PostId 
WHERE a.creationdate >= '8/1/2010'
GROUP BY a.PostId, b.Score
ORDER BY COUNT(a.Id) DESC

fork query

edited sep 19 19

created sep 19 19 jon.doe28633