Subject SubSelect Question
Author Tom Frey
Hi,

maybe someone can help me with this:
I have a table with a column that holds negative and positive volume
numbers.
e.g:
100
-250
300
50
you get the idea ;)

Is there a way to select in one SELECT statement an AVG for all
negative volumes and all positive volumes?