0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- `python%` like tags grouped by years ago

SELECT 
    DATEDIFF(year, Posts.CreationDate, CURRENT_TIMESTAMP) AS years_ago,
    COUNT(*) AS CNT 
FROM Tags
    INNER JOIN PostTags ON PostTags.TagId = Tags.id
    INNER JOIN Posts on PostTags.PostId = Posts.Id
WHERE TagName like 'javascript%'
GROUP BY DATEDIFF(year, Posts.CreationDate, CURRENT_TIMESTAMP)
ORDER BY years_ago DESC
;

fork query

edited jan 30 jon.doe41102

created jan 30 anonymous