filburt1
11-09-2005, 12:41 AM
I don't have any data to test this query on.
SELECT sum( reputation ) AS totalscore, sum( abs( reputation ) ) AS totalpoints, count( DISTINCT whoadded ) AS uniqueusers, count( reputationid ) AS totalratings
FROM reputation
GROUP BY userid
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.
SELECT sum( reputation ) AS totalscore, sum( abs( reputation ) ) AS totalpoints, count( DISTINCT whoadded ) AS uniqueusers, count( reputationid ) AS totalratings
FROM reputation
GROUP BY userid
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.