0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

-- Enter Query Title
    SELECT DisplayName, MinusOne, DownVotes, MinusOne*1.0/(DownVotes) as Ratio
      FROM Users
INNER JOIN
   (SELECT TOP 50 UserId, COUNT(*) AS MinusOne
      FROM Comments 
     WHERE (Text LIKE '%-1' OR Text LIKE '-1%' OR Text LIKE '% -1 %')
       AND UserId = ##UserId##
  GROUP BY UserId) z
        ON z.UserId = Id
     WHERE DownVotes > 0
       AND UserId = ##UserId##
  ORDER BY Ratio DESC

-- Enter Query Description

fork query

created nov 14 11 NullUserException