tag is used in questions with the highest average score, excluding tags used in less than 5 questio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TagId,COUNT(PostId) as numbers, AVG(Score) as sumscore FROM
  (SELECT TagId,PostId,Score FROM 
    (SELECT PostId,TagId,Score FROM (SELECT * FROM Posts WHERE PostTypeId=1) AS P,PostTags 
    WHERE PostTags.PostId = P.Id) AS T) 
  as RELATIONS GROUP BY TagId

Enter Parameters

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