I got this records

seq name score subject
1 tom 10 eng
2 jimmy 11 eng
3 wendy 8 eng
4 mandy 5 eng
5 tom 5 math
6 wendy 4 math
7 jimmy 9 math


what sql statement to used if i want to receive this result.
valuetotal is the cumulative of value score

seq name score subject valuetotal
1 tom 10 eng 10
2 jimmy 11 eng 21
3 wendy 8 eng 29
4 mandy 5 eng 34

dorst622@...