1

Please login or register to vote for this query.

(click on this box to dismiss)

Users who have used more than 1000 upvotes and 0 downvotes

Q&A about the site for members of the workforce navigating the professional setting

-- Motivational
-- Users who have used more than 1000 upvotes and 0 downvotes
SELECT 
    Users.Id, 
    Users.DisplayName, 
    SUM(Users.UpVotes) AS [Upvotes Cast], 
    SUM(Users.DownVotes) AS [DownVotes Cast]
FROM 
    Users
GROUP BY 
    Users.Id, 
    Users.DisplayName
HAVING 
    SUM(Users.UpVotes) > 1000 AND 
    SUM(Users.DownVotes) = 0
ORDER BY 
    SUM(Users.UpVotes) DESC

fork query

created sep 15 11 jadarnel27