I've got a table where I have 3 user names. Scoodo, Scoobii, and Skadda. They have all taken tests. test 1, test 2 and test 3. In each test they have scored 0-100, and what I'm trying to do is run the data from a data base where I have the following rows of data,

What I want is to be able to take this data, and have the following output, but I'm not sure how to do this, can anyone point me in the right direction?

Output wanted, Name: Total Result:
Skadda 144
Scoodo 255
Scoobii 233

Not sure if this is something I do in the SQL statement at the top of the page for querying the database, and organising data, or if I need to build in an IF statement when echo'ing the data out of the data, and into the page.