Need help calculating AVG scores
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.
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.