title: oracle sql select the table and cumulative calculate the score by the date
body: <p><a href="http://i.stack.imgur.com/IDMWU.jpg" rel="nofollow">http://i.stack.imgur.com/IDMWU.jpg</a></p>
  
  <pre><code>+-----+-----------+----------+
  | ID  | TERM      | SCORE    |
  +-----+-----------+----------+
  | 1001|   201009  |        3 | 
  | 1001|   201009  |      1.5 |
  | 1001|   201101  |        2 |
  | 1001|   201101  |        1 | 
  | 1001|   201109  |        2 | 
  +-----+-----------+----------+
  </code></pre>
  
  <p>here is the table 1 that had some kind of gpa score </p>
  
  <p>one person had some score in several terms </p>
  
  <p>is it possible using select statement to group the term and calculate the score</p>
  
  <p><a href="http://i.stack.imgur.com/Zkrqu.jpg" rel="nofollow">http://i.stack.imgur.com/Zkrqu.jpg</a></p>
  
  <pre><code>+-----+-----------+--------------------+
  |ID   |TERM       |      GPA           |
  +-----+-----------+--------------------+
  |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 |
  +-----+-----------+--------------------+
  </code></pre>
  
  <p>etc....</p>
  
  <p>i am using apex to make a report,it seems it create the table by select statement </p>
  
  <p>is it possible select the table like that ?</p>