3C

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT TOP 11 COUNT(*) AS ctr
  , TagsY
FROM (
    SELECT 
        value TagsY
    FROM (

            SELECT
                REPLACE(TagsX,'<','') AS TagsY
                , CreationDate_Year
            FROM 
              (SELECT 
                    YEAR(CreationDate) AS CreationDate_Year
                    , Tags AS TagsX
              FROM Posts) AS X
            WHERE ( CreationDate_Year = 2017)

    ) AS Y
        CROSS APPLY STRING_SPLIT(TagsY, '>')
  ) AS Z
GROUP BY (Z.TagsY)
ORDER BY ctr DESC
;

Enter Parameters

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