0

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы о сайте для программистов

SELECT TOP(##num?100##) 
   Id AS [User Link],
   Upvotes, Downvotes, Reputation,
   CAST(upvotes AS decimal)/CAST(reputation AS decimal) AS [Upvotes divided by rep],
   CAST(downvotes AS decimal)/CAST(reputation AS decimal) AS [Downvotes divided by rep]
FROM Users WHERE Reputation>=##min?125##  
ORDER BY CAST(downvotes AS decimal)/CAST(reputation AS decimal) DESC

fork query

edited jan 19 21

created jan 19 21 Martin20528