oracle sql select the table and cumulative calculate the score by the date

oracle sql select the table and cumulative calculate the score by the date

http://i.stack.imgur.com/IDMWU.jpg
here is the table 1 that had some kind of gpa score
one person had some score in several terms
is it possible using select statement to group the term and calculate the
score
http://i.stack.imgur.com/Zkrqu.jpg
1001 201009 (3+1.5)/2=2.25
1001 201101 (3+1.5+2+1)/4=1.875
1001 201109 (3+1.5+2+1+2)/5=1.9
etc....
i am using apex to make a report,it seems it create the table by select
statement
is it possible select the table like that ?