SELECT trunc(CREATED_ON) as creation2016 , COUNT(CREATED_ON)
FROM DS_HD_ISSUE_LIST_2017
WHERE CREATED_ON BETWEEN '01.10.2015' AND sysdate - INTERVAL '1' year
GROUP BY  trunc(CREATED_ON)
ORDER BY trunc(CREATED_ON);

SELECT trunc(CREATED_ON) as creation2017 , COUNT(CREATED_ON)
FROM DS_HD_ISSUE_LIST_2017
WHERE CREATED_ON BETWEEN '01.10.2016' AND sysdate
GROUP BY  trunc(CREATED_ON)
ORDER BY trunc(CREATED_ON);


SELECT trunc(CREATED_ON) as creation2017 , COUNT(CREATED_ON), trunc(CREATED_ON) as creation2017, CASE
WHEN CREATED_ON BETWEEN '01.10.2016' AND sysdate - INTERVAL  '1' year THEN COUNT(CREATED_ON)
END
FROM DS_HD_ISSUE_LIST_2017
WHERE CREATED_ON BETWEEN '01.10.2016' AND sysdate
GROUP BY  trunc(CREATED_ON);