0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT count(*), c.Text
FROM Comments AS c
WHERE
    c.Text LIKE '%thanks%'
and LEN(c.Text) < 25
and c.Score = 0
GROUP BY c.Text
ORDER BY count(*) DESC

fork query

edited apr 23 15

created apr 23 15 anonymous