Q&A for cartographers, geographers and GIS professionals
--DECLARE @nm nvarchar (35) = ##entername## SELECT CAST(YEAR(Posts.CreationDate) AS VARCHAR(4)), COUNT(0) FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.Id = PostTags.PostId WHERE Tags.TagName = 'powerbi' GROUP BY CAST(YEAR(Posts.CreationDate) AS VARCHAR(4)) ORDER BY 1