title: How to get at least zero value from sum function of oracle pl/sql query
body: <p>Hi this is my query to get count of items<br/></p>
  
  <pre><code>SELECT V2_SA_ISQ_STATUS.ID,
         SUM(CASE WHEN V2_ISQ_DASBRD_AQSTION.ISQSTATUS=5 THEN 1 ELSE 0 END) RFPENDING,
         IMG "img"
  FROM   V2_ISQ_DASBRD_AQSTION
         LEFT JOIN V2_SA_ISQ_STATUS
           ON V2_ISQ_DASBRD_AQSTION.ISQSTATUS=V2_SA_ISQ_STATUS.ID
  WHERE  V2_ISQ_DASBRD_AQSTION.ISQSTATUS=5
  AND    V2_ISQ_DASBRD_AQSTION.CIRCLEID =(
           SELECT CIRCLEID
           FROM IMANAGERUSER 
           WHERE ID=:CURRENTUSERID
         )
  GROUP BY V2_SA_ISQ_STATUS.ID,IMG;
  </code></pre>
  
  <p>if there is now row in <code>V2_ISQ_DASBRD_AQSTION</code> then there is no row in the result, but I want zero count if there is no row in the above table.
  Can anybody help me out please?</p>