Top React Results (10 only)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Web Applications Meta

Q&A about the site for power users of web applications

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;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results