Q&A about the site for science fiction and fantasy enthusiasts
WITH ReactPosts AS ( SELECT Body FROM Posts WHERE PostTypeId = 1 -- Only questions AND CreationDate >= '2020-02-01' AND CreationDate <= '2020-03-01' AND Tags LIKE '%<reactjs>%' -- Posts tagged with reactjs ) SELECT TOP 20 Word, COUNT(*) AS Occurrences FROM ( SELECT value AS Word FROM ReactPosts CROSS APPLY STRING_SPLIT(LOWER(Body), ' ') -- Splitting body into words ) AS Words GROUP BY Word ORDER BY COUNT(*) DESC;