SQL - Sum of positive and negative numbers using subquery

sql

Solution

Your question isn't very clear (no table nor column names given), nor is it clear why you need a subquery (never a good idea if it can be avoided). You can get the values that you want by use of the 'case' statement

The following counts the number of positive and negative values

select sum (case when acolumn >= 0 then 1 else 0 end) as positive,
       sum (case when acolumn < 0 then 1 else 0 end) as negative
from table

whereas the following sums the number of positive and negative values

select sum (case when acolumn >= 0 then acolumn else 0 end) as positive,
       sum (case when acolumn < 0 then  acolumn else 0 end) as negative
from table

Problem

Original source