Q&A for network engineers
select Top 50 TagName as Tag, avg(ViewCount) as AverageViews, sum(ViewCount) as TotalViews, sum(Score) as Scores, sum(FavoriteCount) as Favorites, count(Posts.Id) as Posts from posts inner join PostTags on PostTags.PostID = Posts.Id inner join Tags on Tags.Id = PostTags.TagID where Tags LIKE '%python%' and posts.CreationDate >= cast('2019-01-01' as datetime) and posts.CreationDate <= cast('2022-11-01' as datetime) group by TagName order by count(Posts.Id) DESC