0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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 Tags.TagName IN (
    @TagName1
    , @TagName2
  )
GROUP BY 
  Tags.TagName

fork query

edited feb 20 anonymous

created feb 20 Scott.Willeke