Reputation
 

I don't have any data to test this query on.
[sql]SELECT sum( reputation ) AS totalscore, sum( abs( reputation ) ) AS totalpoints, count( DISTINCT whoadded ) AS uniqueusers, count( reputationid ) AS totalratings
FROM reputation
GROUP BY userid[/sql]
Does it look like it retrieves, for every user who has reputation at all:

• Total awarded score (10 points + 10 points + (-10 points) = 20 points)
• Total possible score (10 points + 10 points + 10 points = 30 points)
• Total number of distinct users who left reputation for this user (filburt1 + filburt1 + Poor Sucker = 2 users)

If so, am I correct in that totalscore / totalpoints = reputation percent? In this case, ~67%?

Or if anybody has a reputation table filled with data I can play with, that would work too.