Like this?

Code:
SELECT TO_CHAR(DOWNLOADDATE,'MON-YYYY') month, COUNT(*) dload,
       SUM(DECODE(acc, 'YES', 1, 0)) YES,
       SUM(DECODE(acc, 'NO',  1, 0)) NO,
  FROM DOWNLOAD
 WHERE DOWNLOADDATE 
            BETWEEN TO_DATE('07/01/2005','mm/dd/yyyy')
                AND SYSDATE
 GROUP BY TO_CHAR(DOWNLOADDATE,'MON-YYYY')
 ORDER BY TO_CHAR(DOWNLOADDATE,'MON-YYYY')
/