with oracle i am trying to count the amount a user spent on items in total. but printing out all the users.

username id totalspent
james 3 10
clair 4 15

how would i count the amount spent where the user id is different every time.

Thanks guys!