Possible Duplicate:
MySQL Query for Average of last 2 attempts

userid scormid attempt Grade
3        12      1      83% 
3        12      2      20%
3        12      3      36%
3        12      4      80%
3        12      5      40%

I need the average grade (ie., (80+40)/2) only for the last two attempts This is the second time I am rising a question, as no one gave me a correct solution for my previous question. Please guys kindly help me with this query

Originally asked by: user1067018 on Stack Overflow