I am trying to get Average of last two records and group them by name.

Tables: S_ORDER

OId ODate Value Name
1 05/01/2011 25 Mike
2 05/01/2011 56 ...