View to score ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT 
    TOP 10
    count(votes.id)/(viewcount) AS [Average Votes Per Viewcount]
FROM
    Posts
    JOIN votes on (postid = posts.id)
WHERE 
    PostTypeId = 2 
    and CommunityOwnedDate is null 
    and ClosedDate is null 
    and votetypeid = 2
GROUP BY
    Posts.id, viewcount
ORDER BY
    [Average Votes Per Viewcount] DESC

Enter Parameters

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