Code:SELECT SUBSTR(TO_CHAR(TRUNC(d.DOWNLOADDATE,'MM')),4,6), COUNT(*) FROM DOWNLOAD d, SUM(DECODE(FEEDBACK, 'Y', 1, 'N', 0)) FEED_BACK_Y, SUM(DECODE(FEEDBACK, 'Y', 0, 'N', 1)) FEED_BACK_N WHERE d.DOWNLOADDATE BETWEEN TO_DATE('07/01/2005','mm/dd/yyyy') AND TO_DATE(TO_CHAR(SYSDATE,'mm/dd/yyyy'),'mm/dd/yyyy') GROUP BY TRUNC(d.DOWNLOADDATE,'MM') ORDER BY TRUNC(d.DOWNLOADDATE,'MM')




Reply With Quote