Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles
DECLARE @TagName1 nvarchar(35) = 'software-industry' DECLARE @TagName2 nvarchar(35) = 'germany' SELECT Tags.TagName , AVG(Score) AS 'Average Score' , AVG(ViewCount) AS 'Average View Count' FROM Posts INNER JOIN PostTags ON Posts.Id=PostTags.PostId LEFT JOIN Tags ON PostTags.TagId = Tags.Id WHERE PostTypeId = 1 -- question AND Tags.TagName IN ( @TagName1 , @TagName2 ) GROUP BY Tags.TagName