Average tag statistics with answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Views, Score and Answers per Tag (with answers)

Electrical Engineering

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

-- Tag statistics
-- Views, Score and Answers per Tag
WITH Questions  AS (
SELECT     avg(cast(q.score as FLOAT)) AS score

    FROM        Posts           q
    INNER JOIN  PostTags        pt
    ON          q.Id            = pt.PostId
    INNER JOIN  Tags            t
    ON          t.Id            = pt.TagId

    WHERE       q.PostTypeId    = 1
    AND         t.TagName       = '##tagname##'
    

)
SELECT *


FROM        Questions  q

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results