SQL Pro

Ответ на #вопрос18

SELECT

 

SUM (CASE WHEN t>0 THEN t ELSE 0 END) sum_pos,

SUM (CASE WHEN t<0 THEN t ELSE 0 END) sum_neg 

FROM weather;