All pastes #213803 Raw Edit

Anonymous

public sql v1 · immutable
#213803 ·published 2006-10-21 17:11 UTC
rendered paste body
SELECT count(votedUserID) AS totalCalcVotes, (sum(rating)/count(votedUserID)) AS avgCalcRating FROM lb_votes_user WHERE rating>0 GROUP BY battleID