0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

-- the fixed numbers are the average for the respective column. see 'Average StackOverflow Score' query

SELECT TOP 50
    Id AS [Post Link],
    CreationDate AS Creation,
    Score/1.6 AS [S],
    AnswerCount/1.72 AS [A],
    CommentCount/1.68 AS [C],
    FavoriteCount/2.36 AS [F],
    ViewCount/1291.29 AS [V],
    Score/1.6 + AnswerCount/1.72 + CommentCount/1.68 + FavoriteCount/2.36 + ViewCount/1291.29 AS [P],
    Tags
FROM
    Posts
WHERE
(Tags in('race'))
  AND
    PostTypeId = 1
  AND
    AcceptedAnswerId is null
Order By [P] Desc

view current version

edited aug 1 14 gustavo pinto

created jul 31 14 anonymous