0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

WITH MatchedTags AS (
    SELECT DISTINCT TagName
    FROM Tags
    WHERE 
        TagName LIKE '%cloudian%' OR
        TagName LIKE '%cognite%' OR
        TagName LIKE '%dryviq%' OR
        TagName LIKE '%firebolt%' OR
        TagName LIKE '%hyperscience%' OR
        TagName LIKE '%nexenta%' OR
        TagName LIKE '%perspectium%' OR
        TagName LIKE '%smart%' OR
        TagName LIKE '%foa%' OR
        TagName LIKE '%tiledb%' OR
        TagName LIKE '%trifacta%' OR
        TagName LIKE '%upsolver%' OR
        TagName LIKE '%zilliz%' OR
        TagName LIKE '%pliops%' OR
        TagName LIKE '%flowwise%' OR
        TagName LIKE '%aisera%' OR
        TagName LIKE '%weights%' OR
        TagName LIKE '%biases%' OR
        TagName LIKE '%ohalo%' OR
        TagName LIKE '%mindbreeze%' OR
        TagName LIKE '%rossum%' OR
        TagName LIKE '%sinequa%' OR
        TagName LIKE '%data.world%' OR
        TagName LIKE '%varonis%' OR
        TagName LIKE '%acceldata%' OR
        TagName LIKE '%atacama%' OR
        TagName LIKE '%experian%' OR
        TagName LIKE '%bigid%' OR
        TagName LIKE '%onetrust%' OR
        TagName LIKE '%crowd%' OR
        TagName LIKE '%rubrik%' OR
        TagName LIKE '%backup%' OR
        TagName LIKE '%dataprotection%'
)

SELECT 
    t.TagName AS Company,
    COUNT(p.Id) AS QuestionCount,
    DATEPART(YEAR, p.CreationDate) AS Year
FROM 
    Posts p
JOIN 
    PostTags pt ON p.Id = pt.PostId
JOIN 
    Tags t ON pt.TagId = t.Id
WHERE 
    t.TagName IN (SELECT TagName FROM MatchedTags)
    AND p.PostTypeId = 1 -- Questions only
    AND DATEPART(YEAR, p.CreationDate) IN (2023, 2024)
GROUP BY 
    t.TagName, DATEPART(YEAR, p.CreationDate)
ORDER BY 
    Company, Year;

fork query

edited dec 12

created dec 12 anonymous