Inspired by https://data.stackexchange.com/stackoverflow/query/971299/search-comments-by-any-keyword-by-date. Comments near the top of the table are more likely to be useless because they will be shorter and are less likely to contain useful information. Please be aware that deleted comments might still show up in the results sometimes.
Also, please DO NOT auto-flag comments using this script. Not all of these comments are necessarily useless. Please check if the comment contains any useful information. If it does, do not flag it. Many if not all of these comments can be deleted from a single non-custom flag, so be careful.
Q&A for meta-discussion of the Stack Exchange family of Q&A websites
with a as (
CASE when Body like '%turmoil%' then 'turmoil' else 'anger' end as word,
count(Id) OVER (partition by CASE when Body like '%turmoil%' then 'turmoil' else 'anger' end
ORDER BY [CreationDate] Asc) as occurances
where Body like '%turmoil%' or Body like '%anger%'
select CreationDate, word, occurances*1.00/max(occurances) over (partition by word) from a
order by CreationDate asc