Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática
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