0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT lower(text), count(text) as num_comments
FROM Comments    
WHERE creationDate BETWEEN DATEADD(DAY,-60,GETDATE()) AND GETDATE()
  and text like '%downvote%' 
  GROUP BY lower(text)
HAVING count(text) > 3
ORDER BY num_comments desc;

fork query

edited apr 23 18

created apr 23 18 ryanyuyu