with oracle i am trying to count the amount a user spent on items in total. but printing out all the users.
username id totalspentjames 3 10clair 4 15
how would i count the amount spent where the user id is different every time.
GROUP BY userid