instruction: Users with highest score from anonymous feedback.
response: SELECT RANK() OVER (ORDER BY SUM(CASE pf.VoteTypeId WHEN 2 THEN 1 WHEN 3 THEN -1 END) DESC) AS Rank, p.OwnerUserId AS "user_link", p.OwnerDisplayName, SUM(CASE WHEN pf.VoteTypeId = 2 THEN 1 ELSE NULL END) AS UpFeedback, SUM(CASE WHEN pf.VoteTypeId = 3 THEN 1 ELSE NULL END) AS DownFeedback, SUM(CASE pf.VoteTypeId WHEN 2 THEN 1 WHEN 3 THEN -1 END) AS Score, SUM(p.Score) AS "total_score", SUM(CASE WHEN p.CommunityOwnedDate IS NULL THEN p.Score ELSE 0 END) AS "noncw_score" FROM PostFeedback AS pf JOIN Posts AS p ON p.Id = pf.PostId GROUP BY p.OwnerUserId, p.OwnerDisplayName ORDER BY SUM(CASE pf.VoteTypeId WHEN 2 THEN 1 WHEN 3 THEN -1 END) DESC LIMIT 100