Find "turmoil" and 'anger' in posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

with a as (
  select CreationDate, 
       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
  from Posts 
  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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results