0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for active researchers, academics and students of physics

SELECT 
    YEAR(CreationDate) AS Year, 
    TagName, 
    COUNT(*) AS QuestionCount
FROM 
    Posts p
JOIN 
    PostTags pt ON p.Id = pt.PostId
JOIN 
    Tags t ON pt.TagId = t.Id
WHERE 
    TagName IN ('python', 'java', 'javascript', 'r') -- vyberte požadované štítky
    AND YEAR(CreationDate) >= 2010 -- filtr na roky
GROUP BY 
    YEAR(CreationDate), TagName
ORDER BY 
    Year, QuestionCount DESC;

fork query

created dec 4 anonymous