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.
GROUP BY userid