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

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 PostId from PostTags 
  WHERE PostTags.TagId = (
     SELECT TOP(1) Id From Tags where TagName = @TagName
  )
)

SELECT COUNT(*) from Posts P
WHERE P.Id IN (
  SELECT PostId from PostTags 
  WHERE PostTags.TagId = (
     SELECT TOP(1) Id From Tags where TagName = @TagName
  )
) AND P.AcceptedAnswerId IS NOT NULL

SELECT SUM(P.AnswerCount) from Posts P
WHERE P.Id IN (
  SELECT PostId from PostTags 
  WHERE PostTags.TagId = (
     SELECT TOP(1) Id From Tags where TagName = @TagName
  )
)

Enter Parameters

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