0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT q.ViewCount, COUNT(c.Id)
FROM Comments AS c
INNER JOIN Posts AS a
ON c.PostId = a.Id
INNER JOIN Posts AS q
ON a.ParentId = q.Id
WHERE
  a.PostTypeId = 2
and q.AcceptedAnswerId = a.Id
and c.Text LIKE '%thanks%'
and LEN(c.Text) < 25
and c.Score = 0
and c.CreationDate < '2015-01-01T00:00:00.000'
GROUP BY q.ViewCount
ORDER BY q.ViewCount

fork query

edited apr 23 15

created apr 23 15 anonymous