0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

SELECT 
    FORMAT(p.CreationDate, 'yy-MM') as [Month],
    COUNT(p.Id) as TotalQuestions
FROM Posts p
INNER JOIN PostTags pt ON pt.PostId = p.Id
INNER JOIN Tags t ON t.Id = pt.TagId
WHERE 
    p.PostTypeId = 1  -- 1=Question
    AND t.TagName = 'java'
GROUP BY 
    FORMAT(p.CreationDate, 'yy-MM')
ORDER BY 
    [Month];

fork query

edited feb 29

created feb 28 anonymous