Select Code to Download

select * from foo;
 name | value 
...
 rat  |    -6
 rat  |   -60
(9 rows)

select name, sum(value) as value from foo group by name order by abs(s
+um(value)) desc;
 name | value 
...
 rat  |   -66
 foo  |    30
(3 rows)