I've a table with scores, like this:
Name | Section |Score
----------------------
John | A | 1
John | B | 3
John | C | 2
Sue | A | 3
Sue | B | 2
Sue | C | 3
Now I want to select the Name and the average score of whom has the highest average score. So, in this case, the average score of John is 2 and Sue's average score is 2.6, so I want the result to be:
Name | Score
-----------------------
Sue | 2.6
How do I achieve this?
Edited by: 785131 on 10-aug-2011 14:49
Ps. I don't know why, but suddenly my handle is set back to a number, while I've set a proper name for it...