DECLARE @TagName varchar(128) = '%##TagName##%' SELECT C...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

DECLARE @TagName varchar(128) = '%##TagName##%'

SELECT COUNT(*) from Posts P
WHERE P.Id IN (
  SELECT DISTINCT(PostId) from PostTags 
  WHERE PostTags.TagId In (
    SELECT Id From Tags Where TagName LIKE @TagName
  )
)

SELECT COUNT(*) from Posts P
WHERE P.Id IN (
  SELECT DISTINCT(PostId) from PostTags 
  WHERE PostTags.TagId In (
    SELECT Id From Tags Where TagName LIKE @TagName
  )
) AND P.AcceptedAnswerId IS NOT NULL

SELECT SUM(P.AnswerCount) from Posts P
WHERE P.Id IN (
  SELECT DISTINCT(PostId) from PostTags 
  WHERE PostTags.TagId In (
    SELECT Id From Tags Where TagName LIKE @TagName
  )
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results