select 
    name, sum(value) as value
  from mytable
  group by name
  order by abs(value) desc