MySQL Forums
Forum List  »  Newbie

Need help calculating AVG scores
Posted by: Bill Shroka
Date: August 09, 2007 03:52PM

Hello,
I use the following query to determine the average score by teams taking a particular test.

SELECT teams.teamname, teams.id, AVG(game_sessions.score) as score
FROM teams, game_sessions
WHERE teams.id = game_sessions.team_id
GROUP BY teams.teamname
ORDER BY score DESC LIMIT 0,25

What I'd like to change now is instead of averaging all of the scores from each team I'd like to only average the top 50% of scores from each team.

Is this possible?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Need help calculating AVG scores
August 09, 2007 03:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.