count() based on current row - multiple rows

[wazzaday]

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!

[r937]

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

SELECT userid
     , SUM(totalspent)
  FROM daTable
GROUP BY userid