using "GROUP BY" correctly

Hello everyone.

I just started to learn Oracle DB managment, actually took course in college.
I have run into problem.
Task is to select best score for each course from this example table:

name student avg(points)
Oracle Jack 8,9
Oracle Tim 4,5
History Jack 7,5
History Mike 9,7
History Tim 5,6

so the result would look like:
name student avg(points)
Oracle Jack 8,9
History Mike 9,7

thank you.

This should be it
-----------------------------------------------------------------------------

SELECT NAME,COURSE,POINTS_SCORED
FROM TEST A
where POINTS_SCORED = ( SELECT MAX(POINTS_SCORED)
FROM TEST I
WHERE I.COURSE = A.COURSE
)
-----------------------------------------------------------------------------

Br,
Santosh Pai