0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain

SELECT 
    YEAR(CreationDate) AS QuestionYear,
    COUNT(CASE WHEN Tags LIKE '%<r>%' THEN 1 END) AS R_Questions,
    COUNT(*) AS TotalQuestions,
    SUM(COUNT(*)) OVER (ORDER BY YEAR(CreationDate)) AS Year_Total
FROM 
    Posts
WHERE 
    PostTypeId = 1 -- 1 = Questions
GROUP BY 
    YEAR(CreationDate)
ORDER BY 
    QuestionYear;

view current version

edited dec 6

created dec 6 aungthurahtoo