SELECT MIN(COL2), MAX(COL2), SUM( CASE WHEN NVL2(COL2, 1, 0) = 1 THEN NVL(COL1, 10) + COL2 + COL3 END) FROM TAB;