MYSQL Query -AVG Last two days

[web21]

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 Peter
3 05/01/2011 09 Robert
4 06/01/2011 21 Mike
5 06/01/2011 52 Peter
6 06/01/2011 04 Robert
7 10/01/2011 28 Mike
8 10/01/2011 57 Peter
9 10/01/2011 03 Robert

MySQL:
SELECT Name, avg(Value) as avg_score
FROM (
SELECT Name, Value FROM S_ORDER BY desc ODate 2
)
GROUP BY Name;

Thank you.!