title: Sql query guide me
body: <pre><code>SELECT (
      SELECT COUNT(*)
      FROM   JLOAN_HI_CSVDATA
      WHERE jloan_hi_csvdata.INSERTEDDATE  &gt;= TO_DATE('15-02-15', 'DD/MM/YY')
        AND  jloan_hi_csvdata.INSERTEDDATE  &lt;= TO_DATE('19-02-15', 'DD/MM/YY')
        and STATUS = 'Success'
      ) AS Success,
      (
      SELECT  COUNT(*)
      FROM    JLOAN_HI_CSVDATA
      jloan_hi_csvdata.INSERTEDDATE  &gt;= TO_DATE('15-02-15', 'DD/MM/YY')
      AND  jloan_hi_csvdata.INSERTEDDATE  &lt;= TO_DATE('19-02-15', 'DD/MM/YY')
      and STATUS != 'Success'
      ) AS Failure,
      (
      SELECT  COUNT(*)
      FROM    JLOAN_HI_CSVDATA
      WHERE jloan_hi_csvdata.INSERTEDDATE  &gt;= TO_DATE('15-02-15', 'DD/MM/YY')
        AND  jloan_hi_csvdata.INSERTEDDATE  &lt;= TO_DATE('19-02-15', 'DD/MM/YY')
      ) AS Total ;
  </code></pre>