1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

-- Acceptance rate by Tag

DECLARE @acceptedAnswerAmount int
DECLARE @questionAmount int

SELECT
   @questionAmount = COUNT(*)
FROM
   POSTS
INNER JOIN
   POSTTAGS
ON
   POSTS.ID = POSTTAGS.POSTID
INNER JOIN
   TAGS
ON
   POSTTAGS.TAGID = TAGS.ID
WHERE
   POSTS.POSTTYPEID = 1
AND
   TAGS.TAGNAME = ##Tag:string##;

SELECT
   @acceptedAnswerAmount = COUNT(*)
FROM
   POSTS
INNER JOIN
   POSTTAGS
ON
   POSTS.ID = POSTTAGS.POSTID
INNER JOIN
   TAGS
ON
   POSTTAGS.TAGID = TAGS.ID
WHERE
   POSTS.POSTTYPEID = 1
AND
   POSTS.ACCEPTEDANSWERID IS NOT NULL
AND
   TAGS.TAGNAME = ##Tag:string##;

SELECT
    (CAST(@acceptedAnswerAmount AS float) / @questionAmount * 100) AS [Acceptance rate]

fork query

created sep 22 10 arthurseveral