0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT year(CreationDate) AS Year, Tags.TagName, count(Posts.Id)

FROM Tags    
    JOIN PostTags ON PostTags.TagId = Tags.Id
    JOIN Posts ON Posts.Id = PostTags.PostId 
WHERE    
    Tags.TagName = 'apache-kafka' 

GROUP BY Tags.TagName, year(CreationDate)

ORDER BY year(CreationDate)

fork query

edited jan 20 20

created jan 20 20 jon.doe33052