CASE WHEN sum(G_SAMAINQTY) is null THEN 0 ELSE sum(G_SAMAINQTY)END

select G_SRCORGID,CASE  WHEN sum(G_SAMAINQTY) is null THEN 0 ELSE sum(G_SAMAINQTY)END from(SELECT YLS.T_STDINOUTWHSK.G_SRCORGID, YLS.T_STDINOUTWHSKS.G_SAMAINQTY
  FROM YLS.T_STDINOUTWHSKS
       INNER JOIN YLS.T_STDINOUTWHSK
          ON YLS.T_STDINOUTWHSKS.G_MID = YLS.T_STDINOUTWHSK.G_ID
 WHERE     to_char (YLS.T_STDINOUTWHSK.G_BILLCRTDATE, 'yyyy') = '2018'
       AND YLS.T_STDINOUTWHSK.G_BILLSTATUSCODE = '01')
       group by G_SRCORGIDselect G_SRCORGID,CASE  WHEN sum(G_SAMA