0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Ethereum, the decentralized application platform and smart contract enabled blockchain

WITH ReactPosts AS (
    SELECT
        Body
    FROM
        Posts
    WHERE
        PostTypeId = 1 -- Only questions
        AND CreationDate >= '2020-01-01'
        AND CreationDate <= '2020-02-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;

fork query

edited oct 11

created oct 11 anonymous