I have a table that looks like so:
userid | amount
---------------
1 | $500
2 | $400
2 | $-100
2 | $10
3 | $10
3 | $10
I run a select sum(amount) from payments group by userid
userid | sum
--------------
1 | $500
2 | $310
3 | $20
I need to modify this query so it returns the minimum, maximum and
average sums. Is there any way I can do this?
-Michael
_________________________________________________________________
http://fastmail.ca/ - Fast Free Web Email for Canadians
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
