[username]

select sum(cost)
from table
group by XXXX